Sorting an Access report by month

  • Thread starter Thread starter Daniel Whitman
  • Start date Start date
D

Daniel Whitman

I have a report sorting by month with the month spelled out. It seems to be
working but months starting with the same beginning are not showing up.

Example it shows me April but not August, shows June but not January or July.

What am I doing wrong?
 
Daniel said:
I have a report sorting by month with the month spelled out. It seems to be
working but months starting with the same beginning are not showing up.

Example it shows me April but not August, shows June but not January or July.

What am I doing wrong?
Click to expand...


Since report sorting needs to be specified in the Sorting
and rouping window, you should provide details about what
you have done there. I suspect that you have used an option
to sort on just the first character.
 
How do I show you the table? As it contain personal information.

On my form I enter in the month # and it stores it in the table with the
month spelled out.

My sorting is is by birth month on entire value and keep whole group
together on one page. Then I sort it by Last name.
 
The table contains First Name, Last name, email address, birth month, a check
box for living with in 100 miles, and a check box for being a club member.

I have the report sorting by birth month (whole value) then a second sort by
last name. The table stores the month as being spelled out
 
Daniel,

Check out the Sorting and Groupings while the report is in design mode that
is generally where a report sorts from. As per Marshalls post you might
have the Grouping sorting by first letter without even realizing it.

Also, by 'show' I meant tell us the fields and how the data is stored, which
is exactly what you did.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Back
Top