| | |
|
|
|
DB field of type Date |
|---|
| message from Hans on 3 Jun 2004 |
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
|
| John Vinson replied to Hans on 02 Jun 2004 |
You can use the some of the date functions to pick apart the
birthdate. I'd suggest a query like
SELECT Month([Birthday]) AS MonthNo, Format([Birthday], "mmmm") AS
MonthName, Day([Birthday]) AS BirthDayNo, [PersonName] FROM yourtable;
Create a Report based on this query; use the Sorting and Grouping
feature of the report to order and group by MonthNo, displaying
MonthName in the section header, and displaying BirthDayNo and
PersonName in the detail section.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
|
Archived message: DB field of type Date (MS Access Database)
