Creating a Quarterly Report

C

Connie

How do I divide up a report by quarter? For example:

2007 Q1
data
data
data

2006 Q4
data
data
data

2006 Q3
etc.
 
C

Connie

Thank you Marshall!
--
~Connie


Marshall Barton said:
Use Sorting and Grouping (View menu) to group on an
expression like:
=Format(datefield, "yyyy \Qq")
and select Yes for the group header property.

Then add a text box to the group header section and bind it
to the date field. Set its Format property to:
yyyy \Qq
Click to expand...
 
M

Marshall Barton

Connie said:
How do I divide up a report by quarter? For example:

2007 Q1
data
data
data

2006 Q4
data
data
data

2006 Q3
etc.
Click to expand...


Use Sorting and Grouping (View menu) to group on an
expression like:
=Format(datefield, "yyyy \Qq")
and select Yes for the group header property.

Then add a text box to the group header section and bind it
to the date field. Set its Format property to:
yyyy \Qq
 
Top