How to return a field based on another date field

[Erl050]

Hello,



I am trying to create a query that will return a data field based on a specific month in a date field. I currently have a table with the following rows: Employee Name, Reason Code, Hours, and Event Date. I would like to query the hours for each month of the year in one query so it could look like the following:

Name Reason Code January [Hours] February [Hours] etc.

I could not find the answer anywhere and I'm about to pull my hair out. Thanks for any advice you all can give!

[pbaldy]

Play with the crosstab query wizard. You should be able to achieve that result, perhaps with a little tweaking.