Help w/Birthdate range. Ex- all b-days in July.

[dar00]

I need to create a report the will give me a list of people the have birthdays for each month. What would the sintax be to give me the all birthdays for each month, it can be one month at a time. It would be great if it would prompt the user to enter the month by number and return all birthdays for that month. Help is greatly appreciated. Thanks

 

[sko]

To get query results that look like this

Birthday Name
Jan 01 Dick
Apr 21 Jane
May 10 Sally


In the query grid Column 1 field row enter
Expr1: Format([DateOfBirthField],"MMM DD&quot
Sort Ascending

Column 2 Field
Name

To Prompt the user for specific month add a third column
Expr2: Month([DateOfBirthField])
In the criteria row add
[Enter the number signifying the month]
Hide the column if you wish.

Base your report on this query.

 

[Cagliostro]

see a supposed yourTable where you need january birthdays, and there is a column BurthDay which is Date/Time type:

select * from yourTable where month(BirthDay) = 1 John Fill

ivfmd@mail.md