Creating forms and labels using different criteria

[Guest]

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

 

[MA]

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

With a query.
It's enought to set the criteria

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it

 

[Rick B]

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.

 

[Guest]

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?

 

[Rick B]

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"))

 

[Guest]

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?

 

[Rick B]

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

 

[Guest]

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.

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

 

[Rick B]

No, you don't perform calcualtions in the table.

Take out the criteria and run the query to see if the age column fills in.

The format of the date and the input mask are not relavent.

--
Rick B

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.

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

 

[Guest]

Thanks so much Rick….your a genius. I removed the criteria and it shows all
the correct ages. I then realized I had quotes around the “between 18 and
55â€. I took those off and whala…..
Thanks again for all your help and patience.

Terry

No, you don't perform calcualtions in the table.

Take out the criteria and run the query to see if the age column fills in.

The format of the date and the input mask are not relavent.

--
Rick B

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.

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