Report - query in access

Hi Lisa

Thanks for the clarification

You could try building your query with the three date fields included, and then entering the parameter for each date on a different row. The syntax for the parameter would be :

BETWEEN [Enter First date] AND [Enter second date]

The only problem would be that you would have to enter the start and end date three times when the query runs; once for each date. This could be tedious.

It is possible to solve the problem by writing a VBA procedure which would simply prompt for the start and end date and then would embed the variables into the sql statement. We actually carry out just such an exercise on the Access VBA course. It is however too invloved to be detailed here.

Hope this is useful

Regards

Stephen