Reports and query date issues

[lite4d]

I have an excel spreadsheet that I am building a database for. I am close to being done but ran into problems with the report function. The database that I have has 1 table that has several months of data that I want to run a report for a specified month. The issue that I am having is that each query(95 in all) that is referenced in my report also requires the [start date] and [end date] requirements. Is there a way to run the report and have the queries use the report date and populate based on that? It might be an easy fix but I just began to get into the report building features of access. Any help is greatly appreciated.

Chris

 

[pbaldy]

95?!? That's a lot, which is a little suspect. In any case, instead of having bracketed parameters, have the user enter the two dates on a form and have the queries get the parameters from there:

Between Forms!FormName.FromTextbox And Forms!FormName.ToTextbox

 

[lite4d]

I didn't understand what you were pointing me too at first, but one the light turned on I got it figured out. Thanks!

Chris

 

[pbaldy]

No problemo!