Placing Headers in report that match group expression

[joe]

I have a report that uses a date field. I have selected to have the
report group by quarter. Now what I would like to do is have the
appropriate quarter # (ex: Quarter 1 or Quarter2 etc..) display in the
reports group heading.

I tried creating an unbound field that reads the value of the date
field and then implements a wildcard scheme to determine if the date
is Q1, Q2 etc. The expression builder will not work with wildcards!!
So, does anyone have any ideas how I can get this to work?

Many thanks in advance!

 

[Marshall Barton]

I have a report that uses a date field. I have selected to have the
report group by quarter. Now what I would like to do is have the
appropriate quarter # (ex: Quarter 1 or Quarter2 etc..) display in the
reports group heading.

I tried creating an unbound field that reads the value of the date
field and then implements a wildcard scheme to determine if the date
is Q1, Q2 etc. The expression builder will not work with wildcards!!
So, does anyone have any ideas how I can get this to work?

Bind the text box to the date field and set its Format
property to:

"Quarter" Q

Or, if you think that's too subtle, set the control source
to any of this kind of expression:

="Quarter " & DatePart("q", datefield)
or
="Quarter " & Format(datefield, "q")

 

[joe]

Bind the text box to the date field and set its Format
property to:

        "Quarter" Q

Or, if you think that's too subtle, set the control source
to any of this kind of expression:

        ="Quarter " & DatePart("q", datefield)
or
        ="Quarter " & Format(datefield, "q")

Marsh,

Awesome! Love these little tricks with MS Access that you would never
find on your own!!

Thanks!!!!!!!!!!!!!!!