show month for grouped dates

[Guest]

I have a report ordered by dated transactions. I have the transactions
ordered by date with monthly transaction totals. I am trying to have the
name of the month as a header for each group of dates. For instance, I want
it to say May above all the May transactions and so on. I want them to be in
order by Month, not done alphabetically.

 

[sajida kauser]

I have a report ordered by dated transactions. I have the transactions
ordered by date with monthly transaction totals. I am trying to have the
name of the month as a header for each group of dates. For instance, I
want
it to say May above all the May transactions and so on. I want them to be
in
order by Month, not done alphabetically.

ok i see wht u mean

 

[Rick B]

In your group header, just put something like this...


="Transactions for the Month of " & Format([YourDateField],"mmm")

or...

="Transactions for the Month of " & Format([YourDateField],"mmmm")