Dates in Report

D

Dirk_Bob

I have created a report in which I group by Salesman and then
by date(month).

When I run the report it looks great, except the grouping by date is in
alphabetical order and not Jan, Feb, Mar, etc.

How do I fix this?
 
R

Rick B

What do you have in your grouping box for that option?

You should use the format option to pull out the long month name.
 
D

Dirk_Bob

Thanks,

In the query it just says "Group by" in the field.

Where would I set the format option to long month?
In the table field definitions?

Thanks again.
 
R

Rick B

In the REPORT, not the QUERY. You need to set the report's grouping and
sorting options.

You could do it in the query too, but you'd have to add a new column. It
makes more sense to use the sorting tools available in the report. You
could also then group by the month and put a group header or footer.
 
D

Dirk_Bob

Probably making this alot more difficult than I should, but when I look at
the sort/grouping options in report for my DocDate field, it only gives me a
choice of
Ascending or Descending.
 
R

Rick B

in the sorting and grouping box, replace your field with...

=Month([NameOfYourDateFieldHere])
 
L

Larry Daugherty

Life will brobably get simpler (after it gets a bit more complex) if
you add a field MonthNum: in your query that returns the DatePart for
the month. That way, Jan is 1, Feb is 2, etc. Use that new field,
MonthNum, to sort/group in your report. You don't need to show the
value in your report, you can use the month's name in the report if
you choose.

HTH
 
L

lovespar

Thanks guys,
I had the same problem and thought I would scroll through some other posts
for an anwer and here you are!
 
Top