PASSING QUERY PARAMETETS TO ACCESS REPORT

[regava]

ACCESS 2000, WINXP
I have a query to print a report using ACCESS 2000. The query requires the user to enter two dates, and I would like to print those dates as part of the report. Is there a way to do it? Following is the query:

PARAMETERS [Enter Start FY] date,[Enter End FY] date;
SELECT Tax, Count(*) AS Total
FROM tblTRacking
WHERE (ClosedDate>=[Enter Start FY] and ClosedDate <= [Enter End FY])
GROUP BY Tax;

The query runs fine. All I need to know is how to access the two parameters in the Report. Thank for your help.

 

[THWatson]

regava
In your report header, put an unbound text box, and put something such as the following (depending on what you want) as the control source for the text box...

="This report includes information for the time period between " & [Enter Start FY] & " " & [Enter End FY]

Be sure that you have the parameter expression precisely as you have them in your query, or you will end up being prompted for parameters twice.

Tom

 

[regava]

Tom
Thank you for your help. It worked. I do appreciate your effort. Have a wonderfull day.

Regava