Recent content by David James

I have a field on my report that looks like this: =DCount("[100%]","[MAIN_TABLE]","[100%] Between #12/01/2011# And #12/31/2012#") I have tried to write it like this: =DCount("[100%]","[MAIN_TABLE]","[100%] Between #12/01/[Enter four digit year]# And #12/31/[Enter four digit year]#") with...

Thanks, I'm gonna give it a shot.

I thought the same thing, but if I go that route, I can't figure out how to do the months across the top as I can't group the date fields into months since some fields in the table are filled in and some aren't so it doesn't know how to put it together.

I have a database that tracks construction milestones by date(i.e. inspection date, construction start, construction finish, turnover.) My boss wants me to be able to report by month what milestones are accomplished at what month. So basically I need a report that shows january through...