Querying against calculated age in a form

[Sokan33]

Age field in my form is calculated from birthdate field but I don't know how
to run a query on the age feild. Thanks for your assistance!

 

[Arvin Meyer [MVP]]

Age field in my form is calculated from birthdate field but I don't know how
to run a query on the age feild. Thanks for your assistance!

Try a query like:

SELECT * FROM MyTable WHERE DateField=[Forms]![MyForm]![txtDateField];
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access