B beatmix01 Golden Member Jun 22, 2001 1,008 1 0 Jan 7, 2004 #1 i'm trying to write a query that will allow me to sum things but also sort things by quarter (fiscally) so I need to have dates specified any ideas
i'm trying to write a query that will allow me to sum things but also sort things by quarter (fiscally) so I need to have dates specified any ideas
BFG10K Lifer Aug 14, 2000 22,709 3,003 126 Jan 7, 2004 #2 Use a group by on the dates that form a quarter and sum the data within each group.