Reporting data from user input

[hartbros]

What I am tiring to do is I have ID numbers on all of my equipment an I want the user to be able to pull a report by hitting a button and having that user put in the ID number and the report pull the make and nay notes I have listed on the various work orders. I hope this makes sense. I would greatly enjoy any insight

 

[Celeste025]

This doesn't seem to make much sense, can you be more specific and clear?

 

[hartbros]

Sorry it was late I have a database that currently houses information about client machines, printers, faxes ect. each machine has a sticker on it w/ an ID number on it like 1022, I periodically so service work on the machines and what I want to be able to do is run a report to were the database asks the user, me, what ID number the report will be bases on I will put in a number , for example 1022, and up will come a report that shows all of the service calls pertaining to ID # 1022. Does that make any more sense

 

[Celeste025]

I would use a Like statement in a query that pops up a box asking for an ID number to run the query. Once you have the query, you can build the report around that.

For the query, in the criteria of the ID #, put something like this:

Like [Enter ID Number or * for All]

That will then only run the query for a specific ID number or * all of them. You can also use the * as a wildcard like if you want all of the ID's that start with 10*, etc.

 

[hartbros]

Sounds good, How do I get it to pop up a box asking the user to input?

 

[Celeste025]

When you put the Like in the query criteria, it automatically does the pop-up thing. You can also do ranges like this:

Between [Enter Beginning Number] and [Enter Ending Date]

The stuff inside of the brackets is the actual text that will appear on the pop-up box. With the between criteria, it will do two pop-ups.

 

[hartbros]

thanks sounds great