Creating a Quarterly Report

[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.

 

[Connie]

Thank you Marshall!
--
~Connie

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

 

[Marshall Barton]

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

2007 Q1
data
data
data

2006 Q4
data
data
data

2006 Q3
etc.

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