I have created a query which sorts a field that is a combination of text values and numbers (from double digits to four digits). The purpose of the query is to sort the values so the text fields are at the top and the remainder of the numbers are in true numerical order (rather than the default order). It works perfectly when I run the query. However, I created a form that used the query for the data and it prompts me to enter parameter values for 2 of the 3 fields I had to create in the query to make the sort work correctly. I just hit enter for both of the prompts, and then it works, but I don't want it to show the prompts. How do I suppress them? I have attached a file that shows the fields I added to the query to make this sort work.
Thanks, Judy
Thanks, Judy