Report with Multiple Criteria

[fredk]

I posted last week but I am still having a real difficult time getting a report to generate based on a form.

The problem is that I have several tables that contain data I need in the report along with a blank address field that must be input on the form.

I think I almost have it- The only problem I have is only getting the one record to print on the report -

This is what I have - A query with all of the tables linked together to get me all of the data with the exception of the address which needs to be entered at the reports run time. I have a form that is based on this query. Included on the form is some blank fields that allow for input of the address.

The report is based on the query (since I cannot base it off of the form?) - It works fine except I cannot filter only the record that I want - I tried to filter on the form but I really need to filter from the query - How do I do this? Normally, I would add a form and set the criteria to the unbound form - Can I still do this - Then I would have one unbound form for the criteria for another form.

Can anyone help? Thanks so much!

 

[welshone]

within your query for the report, do something like this :

SELECT info. needed FROM tables WHERE
AddressField Like [forms]![frmSelectAddress]![txtAddress]

Where frmselectaddress is you form where you choose the report and txtaddress is the text box where you can type in the address.

Then create a button to open the report.

When the report opens it will run the report and show records where AddressField is like the Address you have typed into the text box.

 

[fredk]

Great! Thank you very much for taking the time to help me!!!