Parameter Query Help

[nightmaregenerator]

I have list of about 20 or so users that keeps growing I have implemented a parameter query to successfully isolate the users activity between two dates. But have been unsuccessful at two things.

I can't seem to figure out how to get the parameter query to isolate single names. I have tried:

Like [What is their First Name?]

but it does not bring up any results.

And is there any way for the Parameter query to run and put the results into a default report, that will look the same for all the users, as it is quite tedious having to update 20 or so queries every week then open all these reports adjust them and then print them.

For now it's running like a normal query but I want to have a drop down box that allows you to select the first name and dates and hit OK so it runs

 

[georgedwilkinson]

Run your report from a form and keep your users in a table?

Or run all the reports at once and have Access automatically create a new page for each user?

 

[Banana]

Like [What is their First Name?]

should have a wildcard character if you intend to match a wider string... Without one, it'd be a slow way of doing a equality comparsion. Try this:

Like [What is their First Name?] & "*"

However, I concur with George- it's much preferable to use a form to provide criteria for report and having your users in a table so it can be referenced via a listbox or a combobox. Such approach certainly will be less error prone than using parameter query which you basically have to hope they don't try and enter just a single letter or accidentally click OK and get all results.