Thanks Rick! I followed your instr. but after running the query, I get no
data.
The date is set to short date and the Input Mask is set to 99/99/0000;0;_
in my table. I thought it might have something to do with the format.
I wonder if I could insert a column in my table called "Persons Age" and have
it calculate the age with the given date. Does that sound feasible? Would
you have the calculation? Thanks again. Really appreciate it.
Rick B said:
Nope you would type the entire text I gave you below (including the colon
and the formula) in the field name.
In the criteria you'd put Between 18 and 55
--
Rick B
Thanks again Rick but I'm just getting into Access and kinda feeling my
way
around.
When creating a new column I would go to the design view type in PersonAge
in the field name? Would the date formula go into "Criteria" and the
"Between 18 and 55" go into the "or" field? Please forgive my ignorance.
:
You would use the following in a new column of your query to calcualte
the
age. Then put criteria under it to say "Between 18 and 55"
PersonAge:
DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))
--
Rick B
Thank you....... One other ?
If the adult age is between the age of 18 and 55, and have the persons
birthdate,
is there a way to convert that to age and then do a query on age?
:
Just build that criteria into your queries.
You could make one query that asks the user for a bunch of criteria,
or
make
separate queries and reports for the various needs.
--
Rick B
I have a database that I need to create multiple labels with
different
criteria.
I've used label wizard for all my addresses but what if I want to
make
labels
for a specific state or zip. The database also has the person's
birth
date.
How
would I create a report and labels for people over 55 (Seniors) or
adults,
ages
between 18 and 54?
Thanks for your help
Terry