show month for grouped dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
jkevern said:
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.
Click to expand...
ok i see wht u mean
 
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")
 
Back
Top