| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 90402 | 2008-06-02 00:14:00 | Access query | jwil1 (65) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 674846 | 2008-06-02 00:14:00 | I want to create a query that asks a user to enter a DOB as a 'minimum' age when an Access 2007 query is opened, then display all records that have a DOB that falls between today and the date the user entered. I have successfully set one up looking for male or female gender (using this expression) Like [Please enter Gender (M: Male, F: Female):] How can I do this?? |
jwil1 (65) | ||
| 674847 | 2008-06-02 01:35:00 | try this select * from TableName where DOB < [start date]; as a starting point ill do some access work soon seew ant I can do with it |
beama (111) | ||
| 674848 | 2008-06-02 02:03:00 | not a bad first attempt but I think this maybe closer to your needs SELECT Table1.dob FROM Table1 WHERE ((Date()<[Table1]![dob])); If you need to expand on this use the expression builder in access right click in conditions area when building your query using the wizard good luck |
beama (111) | ||
| 1 | |||||