Newbie help with query

[David James]

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 December across the top, with the milestones down the side. The data should be counted totals of each project by milestone in the month column. So if in January there were three projects that had the "inspection date" field filled in, it would count "3" in the report under January. Does this make sense what I am asking? Also, I work for a non-profit so we are still using 2003.

Any help would be greatly appreciated.

example:

..........................Jan...Feb...March...April...May...Etc
Inspection Date.......3......0.......0........1.......2
Construction Start...1......2.......6........4.......2
Construction Fin......0.......0.......5........8......4.
Turnover................1......1........0.......2.......0

 

[speakers_86]

This looks like a crosstab query. I've never actually needed to use one, but just google it, or search youtube for examples.

 

[David James]

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.

 

[vbaInet]

Still using a Crosstab query:

1. Column Header: Format([InspectionDate], "mmm")
2. Value: will be Count based on Month([InspectionDate])

 

[David James]

Thanks, I'm gonna give it a shot.