OBP. Yeah, I was kinda thinking the same thing.

There are a few methods to do this
a. Hard code the Filter in the Report. (Easy). I only want the report to select a specific range of dates within the entire table so I need to send those dates when the report is printed.
b. Hard code the filter in the Report's underlying Query. (Easy).This won't allow me to control the dates very easily
c. Program the Query from the Form. (Fairly easy).. I was thinking about this. If I use some public date variables and set them with VBA, that might work. But, I am calling the reports from many directions and that might get confusing. But this looks like the best option
d. Create the Query for the Report using the QueryDef. (Harder)
e. Create an SQL and assign to the report using VBA. (Also Harder).

thank you for your ideas. I will let you know the solution once written


JoinedMar 2005Posts2,592Location

There are a few methods to do this
a. Hard code the Filter in the Report. (Easy)
b. Hard code the filter in the Report's underlying Query. (Easy)
c. Program the Query from the Form. (Fairly easy)
d. Create the Query for the Report using the QueryDef. (Harder)
e. Create an SQL and assign to the report using VBA. (Also Harder)