Birthday Report

[Melissa]

I have the birthdates of my students recorded. The field
includes the year (mm/dd/yyyy). I teach sophomores
through seniors. I would like to print a monthly birthday
list that disregards the year, but orders the list by day
for the month I select.

Example of the output I currently get:

Suzie Smith 10/15/1987
John Teasdale 10/4/1988
Amy Scott 10/9/1989

What I want:

John Teasdale 10/4
Amy Scott 10/9
Suzie Smith 10/15

Is this possible? If so, how do I accomplish it?

 

[Fredg]

Melissa,
Paste this into a new query SQL view window.

SELECT [FirstName] & " " & [LastName] AS Student,
Format([DateField],"mm/dd") AS Birthdays
FROM YourTable
WHERE (((Format([DateField],"mm"))=Format(Date(),"mm")))
ORDER BY Format([DateField],"mm/dd");

Change the field and table names as needed.

If you wish to enter then month wanted, then use:
WHERE (((Month([DateField]))=[What Month?]))

Enter the month number when prompted.

This will be more flexible, as you can use it the month before needed.

 

[martin]

In your query I assume your using one for this report your
first thing should be day([birthdate]) sort ascending. If
you want it for more than just one month you would do month
([birthdate]) before day with sort ascending.

 

[Fredg]

Melissa,
I sent my previous message a moment too soon.
Make the query the Record source for your report.

Note ... you will need to set the Report's Sorting and Grouping
box to get the correct sort in the report.
In Design View click:
View + Sorting and Grouping
Enter
Birthdays
on the first line.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

Melissa,
Paste this into a new query SQL view window.

SELECT [FirstName] & " " & [LastName] AS Student,
Format([DateField],"mm/dd") AS Birthdays
FROM YourTable
WHERE (((Format([DateField],"mm"))=Format(Date(),"mm")))
ORDER BY Format([DateField],"mm/dd");

Change the field and table names as needed.

If you wish to enter then month wanted, then use:
WHERE (((Month([DateField]))=[What Month?]))

Enter the month number when prompted.

This will be more flexible, as you can use it the month before needed.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

I have the birthdates of my students recorded. The field
includes the year (mm/dd/yyyy). I teach sophomores
through seniors. I would like to print a monthly birthday
list that disregards the year, but orders the list by day
for the month I select.

Example of the output I currently get:

Suzie Smith 10/15/1987
John Teasdale 10/4/1988
Amy Scott 10/9/1989

What I want:

John Teasdale 10/4
Amy Scott 10/9
Suzie Smith 10/15

Is this possible? If so, how do I accomplish it?