This should help: http://www.techonthenet.com/access/functions/date/datediff.htm On Thu, 17 Feb 2005 22:27:05 +0530, Shiok Far-eastern Cuisine <chef at shiokfood.com> wrote: > 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 > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > -- Ken Chase Freelance Web Design http://www.kenchase.com