print parameter valus on your report

[NaomiGlenn]

I am doing a reprot from a query and want the paramenter values to show up on the report but not sure how to do that.

For example: From: start date To: end date

 

[GinaWhipp]

Something like...

="Your Words: " & [Forms]![YourForm]![txtStartDate] & " and " & [Forms]![YourForm]![txtEndDate]

 

[RenaG]

I'm jumping on this thread because I am needing to do something similar (or sounds like it at least).

I created a query:

SELECT ReferralCategory.ReferralCategory, 
     Count(PatReferralTo.ReferralCategoryID) AS CountOfReferralCategoryID
FROM ReferralType 
     INNER JOIN (ReferralCategory 
     INNER JOIN (Patient 
     INNER JOIN PatReferralTo ON Patient.ID = PatReferralTo.PatientID) 
     ON ReferralCategory.ID = PatReferralTo.ReferralCategoryID) 
     ON ReferralType.ID = ReferralCategory.ReferralTypeID
WHERE (((PatReferralTo.ReferralDt)>=[Enter Beginning Date] 
     Or (PatReferralTo.ReferralDt)<=[Enter Ending Date]))
GROUP BY ReferralCategory.ReferralCategory, 
     ReferralType.ID, Patient.ProgramID
HAVING (((ReferralType.ID)=2) AND ((Patient.ProgramID)=RetProgID()))
ORDER BY ReferralCategory.ReferralCategory;

Then off that query, I created a report. All this works great. What I need to do is get the date range into the Report Header of the report.

How do I do that?

TIA!
~RLG