Frustrated. Sorting by Month. Tried EVERYTHING!

  • Thread starter Thread starter Cristina
  • Start date Start date
C

Cristina

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!
 
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.
 
KARL DEWEY said:
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.
Click to expand...

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
 
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!!

KARL DEWEY said:
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.

--
KARL DEWEY
Build a little - Test a little


Cristina said:
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!
Click to expand...
Click to expand...
 
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.

--
KARL DEWEY
Build a little - Test a little


Cristina said:
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!!

KARL DEWEY said:
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.

--
KARL DEWEY
Build a little - Test a little


Cristina said:
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!
Click to expand...
Click to expand...
Click to expand...
 
It still works!!! Thanks

KARL DEWEY said:
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.

--
KARL DEWEY
Build a little - Test a little


Cristina said:
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!!

KARL DEWEY said:
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.

--
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.

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!
Click to expand...
Click to expand...
Click to expand...
 
It still works!!! Thanks

KARL DEWEY said:
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.

--
KARL DEWEY
Build a little - Test a little


Cristina said:
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!!

KARL DEWEY said:
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.

--
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.

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!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top