Saving parameter data for a report

  • Thread starter Thread starter Bob Watson
  • Start date Start date
B

Bob Watson

If I had the query:

PARAMETERS [Begin Date] DateTime, [End Date] DateTime;
SELECT Nz(Registration.Age, "Blank") AS RegistrationAge,
Count(Registration.Age) AS RegistrationCount
FROM Registration
WHERE (((Registration.[Date Attended])<=[End Date]
And (Registration.[Date Attended])>=[Begin Date]))
GROUP BY Registration.Age;


which is the "record source" of a report. How do
I get the [Begin Date] and [End Date] into
the report? The report rMyReport does not "know"
about this parameter data just because it uses
the query, does it?

TIA,
Bob
 
Back
Top