Display record count on an Access report

How do I display in a textbox on my report the record count from the following query. This query is the record source of my report:

SELECT * FROM MyQuery WHERE [MyDateField] >= #1/1/2011# ORDER BY [MyDateField] DESC;
dbfromnewjerseyAsked:
Who is Participating?
 
omgangConnect With a Mentor IT ManagerCommented:
Add to the report footer a text box with this as the control source

=Count([MyDateField])

OM Gang
0
 
dbfromnewjerseyAuthor Commented:
Great. Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.