DB field of type 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
Click to expand...

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