I am trying to create a query in design view (Access 2010) whereby the user is prompted for a city with a parameter prompt I want the user to see the results whereby all records for all cities will be returned if no value is entered. I am not sure how to enter the criteria in query design view. Can you help?