MS Access Query Question

[preslove]

Access noob here. I'm creating a database in Access 2003 to track workflow & I'm making queries to total units of work in monthly, quarterly, and yearly increments.

My problem is that Access in table view shows the October-December quarter as Q4 2008, while my workplace considers that quarter to be Q3 2008.

In design view, the field code is as follows on the next line.
Date By Quarter: Format$([CSU Logs].Date,'\Qq yyyy')

What do I have to change in order to make it Q3 and not Q4.


Thanks!

 

[bruceb]

Start here:

http://blogs.msdn.com/crm/arch...ing-and-budgeting.aspx

 

[NeoV]

you could make another table that simply lists the months and what quarter they belong to - then cross-reference your workflow data with the new table, and use the Q from there as your grouping item