Access queries 1

[robheeley]

In an Access database containing personal details including dates of birth, how do I create a query to extract all those now aged 1 year, 18 months, 2 years etc? I would need to ru this on a weekly basis.

 

[nberryman]

A date is just a number displayed in a date format.

Try between Now() - 365 and Now() - 730

This will give anyone between 1 year and 2 years old

Have a play with that and take a look at the help on Datepart() and other date functions to learn more



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com