reports??

in my system i must generate reports- in my reports form in vb the user can select 4 diff types of report to generate and they can select a date range for which they want to view these reports and all of this information comes back to a data grid on the screen which they can copy and paste to excel if desired.

Also they can click on a preview report button which causes access to open up and opens the required report(by means of a macro) except this report is based on a query I have created in access and selects all information but does not deal with the date range, i.e it wont compare to the information in the data grid as this will be based on a specified date,

Is there any way you think that I could get the date to work in my paper report in access,,, it sounds a little impossible to me, but maybe someone might be able to help!!

I would think that you can pass a string to the report's filter property. Although I'm not sure as I've never automated Access from a Vb application. Regardless post the code you are using to open the report.

-Jack