Unanswered: Prompt user for report filter criteria
I have a registration database for 15 training events in 15 different cities. All the registered attendees are listed in one table, with a field indicating which city they are attending.
I have a registration report that I need to be able to pull up for any city, but I don't want to save 15 versions of the report. Can I make the report prompt the user for a city name as it opens, and then apply a filter to the data, so that the report shows only attendees from that city?
Maybe it's not a filter. Maybe it's a criteria in the underlying query. Either way, how can I make this work?