Report question in Microsoft Access 2003

[marlie]

Hi

I need a report that is based on a parameter query. The report is to view records of courses that will expired between certain dates. I have a query created that calculates the expiry date field based on the date completed and the months valid. I entered a parameter for the course, it works but if I enter a parameter for the start date and end date, I get nothing. if I type in the criteria as >#01/01/2000# and <#01/01/2010#, i will get the correct results.

My goal is to supply the parameters directly to the report, the users do not need to see the results of the query, just the report.

So my two questions are: Why does the expiry field show no results when I use a parameter,
and

Can I create a form that supplies the three parameters, course name, start date, end date, directly to the report.

Marlie

[marlie]

I fixed it.

It was a stupid error I made.

Marlie