Report Queries

[ShannonC]

Is there a way to have a box pop up when you click on a report and enter in parameters? I created huge reports with all the information for several different subcontractors and I want the attorney to be able to click on the report and enter in the subcontractor's name and only the information linked to that subcontract to show up on the report.

Normally I create one report and copy and past the same report over and over again and link it to the different queries, but this is a large case and it would take forever to do that.

 

[Andrew Fergus]

Hi
Assuming your report is based on a query (if it isn't then it should be) then under the [contractor] or [contractor id] field enter something like this in the criteria :

=[Enter the contractor id / name]

but please be aware that the person using the database will need to enter the exact id or name to get any results in the report - if a word is mis-spelled it is likely the report will return nothing. There are ways around this problem and if it is an issue then post back with a reply.
HTH, Andrew.

 

[ShannonC]

How can I get it to filter by any part of the name?

 

[Norie]

Try this in the criteria:

Like "'*" & [Enter the contractor id/name] & "*'"