Question Locked
access 2007 advance count under reports
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm trying to get a number withing a report. I created a group to count all the records. I want it to count only records created in 2009
this is what I think I need:
=count(Year([CREATEDATE])=2009)
needless to say it doesn't work.
a 'WHERE' statement doesn't work there.
any ideas?