G Guest Jul 24, 2005 #1 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!
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!
A Arvin Meyer [MVP] Jul 24, 2005 #2 Sokan33 said: 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! Click to expand... 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
Sokan33 said: 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! Click to expand... 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
