Frustrated. Sorting by Month. Tried EVERYTHING!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cristina - 18 Mar 2008 23:51 GMT

I have read many of help topics on this same exact subject. I am new to
access, and self taught.

I am using Access 2003.

Here is what I have. I have a Form DB with all of Clients. The form is based
on a table labled "Contacts". We like to send out birthday cards to our
clients. So I want to create a report that has our client correspondence info
along with their birthdates.

I was able to create a report with the clients information, but I want to
sort it by Month only. But right now it's grouping together by Year.

I have tried all the suggestions previously posted, but none have worked. If
somebody can spell it out. What I should do. I can start the report from
scratch if I need to take a different route.

Please have patience. And please please HELP!!!!!!!

Thank you much!

Reply to this Message

KARL DEWEY - 19 Mar 2008 00:10 GMT

In your query used for the report add a calculated field like this ---
Birth_Month: Month([YourDOBfield])
Then in design view of the report click on menu VIEW - Sorting and Grouping.
Select Birth_Month field.

Signature

KARL DEWEY
Build a little - Test a little

> I have read many of help topics on this same exact subject. I am new to
> access, and self taught.
[quoted text clipped - 16 lines]
>
> Thank you much!

Reply to this Message

Larry Linson - 19 Mar 2008 04:08 GMT

> In your query used for the report add a calculated field like this ---
> Birth_Month: Month([YourDOBfield])
> Then in design view of the report click on menu VIEW - Sorting and

Grouping.

> Select Birth_Month field.

Comparing your question and Karl's answer, the _key issue_ is in his first
sentence: Use a Query for the RecordSource of your Report. You can include
the Calculated Field he suggests in a Query, but you can't do calculations
in a Table.

Larry Linson
Microsoft Office Access MVP

Reply to this Message

Cristina - 19 Mar 2008 19:10 GMT

FINALLY. I got it to work!!! Now, one more question.

Now that it's sorted, I want to label each group Jan, Feb, March, etc. Right
now it's labeling the group 1, 2, 3, etc.

Thank you so much for your previous help!!

> In your query used for the report add a calculated field like this ---
> Birth_Month: Month([YourDOBfield])
[quoted text clipped - 21 lines]
> >
> > Thank you much!

Reply to this Message

KARL DEWEY - 19 Mar 2008 20:39 GMT

In your query used for the report add another calculated field like this for
Jan, Feb, Mar, etc ---
Month_of_Birth: Format([YourDOBfield], "mmm")

For January, February, March, use ---
Month_of_Birth: Format([YourDOBfield], "mmmm")

Sort on one but display the other.

Signature

KARL DEWEY
Build a little - Test a little

> FINALLY. I got it to work!!! Now, one more question.
>
[quoted text clipped - 28 lines]
> > >
> > > Thank you much!

Reply to this Message