access 2007 advance count under reports - TechRepublic
Question
May 18, 2009 at 10:07 PM
jas03

access 2007 advance count under reports

by jas03 . Updated 17 years, 2 months ago

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?

This discussion is locked

All Comments