How can I organize records by quarter?

J

Jolram

I know how to put a date into a form, but how do I make that date by ongoing
quarter rather than by days?
 
A

Albert D. Kallal

Simply build a nice query with all the fields you need, and in include the
date field.


Now, add one more column to the query builder like:


MyQuarter:format([YourDateField],"q")


The above column will return the quarter. Now, fire up the report builder,
and simply make a "grouping" by the above quarter. Now, you can show all
data by quarter..and do all kinds of sums/ totals by quarter..
 
Top