Sorting an Access report by month

[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?

 

[Gina Whipp]

Daniel,

Might help to show the query and/or table that the report uses so we can see
what/why that is happening.

--
Gina Whipp

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

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

 

[Marshall Barton]

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?

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.

 

[Daniel Whitman]

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.

 

[Daniel Whitman]

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

 

[Gina Whipp]

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