Enter parameter query, and alphabetical reporting problem

[kull]

Hi folks

I've got a query and button set up on a 2 different forms to generate a mailing list. Users can either go to one form with the intent to generate the list for 2X5 mailing labels or go to the other form to generate a list for 3X10 labels. Both the query generator buttons and the view report buttons for each of these label types appear to have the same programming, except that the report formats are different.

Here is the problem. When I query the database to produce 3X10 labels, I set up the query to display the mailiing addresses by city in alphabetical order, which it does. When I view the report everything is in alphabetical order by city. When I do the same for the 2X5 labels, the query displays the records in the requested order, but when I view the report, the address labels aren't in alphabetical order anymore. I assume the problem is with the report, but the only difference between the 2x5 labels and the 3x10 is the sizing. What could be the problem causing the 2x5's to lose alphabetical order???

One other thing. After running either queries, when I click on the button to generate the label reports, I get a statement saying ENTER PARAMETER VALUE for a few of the variables (ex. First Name, Address, Postal Code, etc.). How do I get rid of this???

Thanks to anyone who can help. [sig][/sig]

 

[kathryn]

In report design view, look at sorting and grouping. For some reason, sorting and grouping doesn't carry through from queries to reports.

You might also look and see if the fields that are generating the Parameter Value request are listed in the sorting and grouping. If they are and if they are not truly field names, then that's your problem. [sig]<p>Kathryn<br><a href=mailto: > </a><br><a href= > </a><br> [/sig]