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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top