date

I have a DB field of type Date (dd-mm-yyyy)
The contents of this field is the birthday
To make a birthday-calendar I would like to know how to do that.
The output should be something like:

January
1 mr Johnson
17 mrs Williams

February
2 mr Brooks
24 mr Simson
etc

What should be the contents of the criteria in a query

Can someone help!
Thanks,
Hans

On Wed, 9 Jun 2004 00:39:41 +0200, "Hans" wrote:

I have a DB field of type Date (dd-mm-yyyy)
The contents of this field is the birthday
To make a birthday-calendar I would like to know how to do that.
The output should be something like:

January
1 mr Johnson
17 mrs Williams

February
2 mr Brooks
24 mr Simson
etc

What should be the contents of the criteria in a query

Can someone help!

Hm. I did, just a couple of days ago - same example dates. Don't know
if it was for you but I remember the 1 mr Johnson line!

Create a Query with four fields:

SELECT Month([birthdate]) AS MonthNo,
Format([birthdate], "mmmm") As MonthName,
Day([birthdate]) As DayNo,
Title, LastName
FROM yourtable;

Then create a Report based on this table. Use the "Sorting and
Grouping" dialog of the Report to group by MonthNo; display MonthName
in the monthno header; and sort by DayNo within each month.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public