date

  • Thread starter Thread starter Hans
  • Start date Start date
H

Hans

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

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