[thelist] SQL query help: dates

Shiok Far-eastern Cuisine chef at shiokfood.com
Thu Feb 17 10:57:05 CST 2005


Hi folks.

I'm a bit rusty on my SQL so I'm asking for help.

I have an Access database with a list of customers and their personal info.
This includes birthdays.

I want to run a query that will return the names of customers whose
birthdays fall in the 10 days from today. The name field is called
CustomerName and the birthday field is called, well, Birthday.

Any help appreciated.

<<   *   >>
Madhu Menon
Shiok Far-eastern Cuisine
Visit: http://www.shiokfood.com

Chef's Notes: http://shiokfood.com/notes




More information about the thelist mailing list