Birthday Query

[themurph2000]

i renamed the table when i looked at what you had wrote.

I give up! in way over my head lol. But this might be the easiest option. Here is the file itself if you dont mind looking at it.

http://www.centrepointbowl.com/access/Database.accdb

Raskew had it right, but the formula for the birthday was reversed. Here it is corrected. This will be a new field in your query.

Upcoming: DateDiff("d",Date(),DateSerial(Year(Date()),Month([DOB]),Day([DOB])))

Then, in the new Upcoming field, write between 1 and 21 in the criteria box
I tested it, and it worked.

 

[marc515151]

Thank you all for being so patient! and so extremely helpful! greatly appricate all your help and support!

 

[Brianwarnock]

I had it doing the Diff and using between 1 and 21 in post 3 but post 8 appeared to indicate that marc wanted to quote a date range, and I cannot see how the different Month would fail it, not a 2007 bug is it.

Brian

 

[themurph2000]

I had it doing the Diff and using between 1 and 21 in post 3 but post 8 appeared to indicate that marc wanted to quote a date range, and I cannot see how the different Month would fail it, not a 2007 bug is it.

Brian

Oh, I wasn't sure if he was determined to have the actual dates in as part of the criteria in the query. Doesn't seem to make sense, though. Why do that kind of work when you can have Access do it for you?