Just want a plain Birthday Report

[Palomino33]

Hi, I've read through quite a few pages of forums and havn't see this question yet. I know it's easy for you experts, maybe someone can give me this.

I have:
1. A table of 100 people. Just three fields...Name, Birthdate, Active (which is a yes/no field).
2. The Birthdate field is formatted for date in the table.

I want:
To Click on my query and it ask me: "Enter the representing number for the month you want to see".... I then want to put in a number (1 through 12)....say I put in 5, I want to get back all of my May birthdays.

I've tried this several times over the years, and always gave up, and now have a real need for this. I know I am making it harder than it is....I just can not figure it out.

[June7]

Create a field for the birth month in query by expression.

BirthMonth: Month(Birthdate)

Now put the parameter prompt in the Criteria row for this constructed field.

[ssanfu]

To add further to June's reply, the SQL would look something like:

SELECT YOURTABLE.Name, YOURTABLE.Birthdate, YOURTABLE.Active, BirthMonth: Month(Birthdate) 
FROM YOURTABLE  
WHERE Month([Birthdate]) = [Enter a number Between 1 and 12] 
ORDER BY YOURTABLE.Birthdate;

Change the blue text to your table name.

Note that "Name" is a reserved word in Access and shouldn't be used as object names.

[Palomino33]

Hey guys, just found your responses. Thank you so much, will try this as soon as I get home from work today

[Palomino33]

Guys, that is too easy! I knew I was overthinking it Thank you thank you thank you!!!!! and Thank you again!!!!!

[Palomino33]

One more itsy bitsy thing....Now in my report...how can I convert a #1 to Jan, and 2 to Feb, and so on?

[June7]

Use the original birthdate field. Do an expression in query or in textbox on report.

BirthMonthText: Format([birthdate],"mmm")

[Palomino33]

Works perfectly!!!!!!!! Thank you!! You are too sweet! Hugs from Omega Georgia!!!!!!!!!!