Re: Query that returns applicants over age 18
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Tue, 28 Nov 2006 11:50:01 +0800
Try this in the Criteria row of your query under the DOB field:
<= DateAdd("yyyy", -18, Date())
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Cindy" <Cindy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3578A7E2-CE00-4FA4-A1AC-F6F5BC0ADA01@xxxxxxxxxxxxxxxx
I have a querty that I want to look at DOB field and calculate if applicant
is over age 18 w/o having to change the ">" date each time I run it.
.
- Prev by Date: Re: Multiple Independent Criteria Query
- Next by Date: Re: query not populating
- Previous by thread: [ Autofill datatable columns with increasing numbers ]
- Next by thread: Re: query not populating
- Index(es):
Relevant Pages
|
|
