Placing Headers in report that match group expression

  • Thread starter Thread starter joe
  • Start date Start date
J

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!
 
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?
Click to expand...


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")
 
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")
Click to expand...

Marsh,

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

Thanks!!!!!!!!!!!!!!!
 
Back
Top