How do I put a prompt in a query.

[qwert231]

I want my query to look up and sort data based on a batch number entered by the user. For example, we may have a several lines of data for batch 111222 and we want all of those sorted. Can I create a prompt in my query that will ask which batch to sort through and then use the number the user enters to complete the query? What would be the best way to do that if not in the query. Thanks.

 

[Databaseguy]

In the criteria of the field you want a prompt, type:

[Please enter batch]

When you run the query, a dialog nox will pop up asking you for the batch. Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[qwert231]

Cool, that works. Cept now the report that pulls from this query is broken. I am creating labels, and instead of printing side by side (ie. Row 1, Col 1, Col 2, Col 3, Row 2) it prints all in 1 row. Not sure where to set the in the report back to 3 columns.