Microsoft Access

[LostSheep]

I have a massive database setup with Microsoft Office Access 2003 and I'm looking for a way to filter the records in a specific way. At the moment the database is setup with names, addresses and dates of birth. The filter I'm trying to work out is one that will list all the records with a date of birth over a certain age, e.g all records over the age of 60. The problem is I've set the date of birth column like this, 01/01/1965. Is there anyway I can make a filter do what I'm trying to do? Thanks!!

[OBonio]

I didn't think Access was capable of handling massive databases....

SELECT * FROM table WHERE DateDiff(yyyy, DoBField, Now) > age

DateDiff returns the number of years between two dates. If you're not familiar with SQL, just use the DateDiff() > age bit as the filter.

[OBonio]

More details on DateDiff here :

http://www.techonthenet.com/access/functions/date/datedi ff.php

[fo3nix]

what you're wanting to do is called a Query. You'll find a wizard within Access for creating one of these.

As OBonio thinks, Access is notoriously terrible for large databases. (what do you mean by "massive"?) I would suggest using something that can stand up to large data transfers much better, but maybe it's too late now.