Labels: 1 person, 2 addresses

[DebbieG]

I am creating a database for a small department in a university. Each
student in their database can have 2 mailing addresses. They wanted mailing
labels pulling just the 1st address. No problem.

However, now they want a second label for students that have a second
mailing address.

Any ideas of how I can accomplish this?

Thanks in advance for any help.
Debbie

[Steve]

Your student table either has fields for two addresses or you have a separate
address table. In either case, you need to create an appropriate query that gets
the student names and the addresses you want. Your label is based on this query.
Basing your labels on a query is a good idea for other reasons too. With a query
you could print labels for certain groups of students by using criteria in your
query. For example, you might only print labels for students in a certain class,
who live in a certain dorm or who belong to a certain fraternity or sorority.
You might even just want to print labels only for students over at 'Animal
House'! :)

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"DebbieG" <debbieg@access us-REMOVE-THIS-.net> wrote in message
news:vr******** ************@ac cessus.net...

I am creating a database for a small department in a university. Each
student in their database can have 2 mailing addresses. They wanted mailing
labels pulling just the 1st address. No problem.

However, now they want a second label for students that have a second
mailing address.

Any ideas of how I can accomplish this?

Thanks in advance for any help.
Debbie

[DebbieG]

I have a separate table for the addresses. I added the 2nd set of addresses
information to the query I am using for my labels. But how do I create 2
separate labels for a student if they have information in both addresses?
Do I change the textboxes on my label report? If so, how?

"Steve" <sp**@nospam.sp am> wrote in message
news:U0******** **********@news read2.news.atl. earthlink.net.. .
Your student table either has fields for two addresses or you have a
separate
address table. In either case, you need to create an appropriate query that
gets
the student names and the addresses you want. Your label is based on this
query.
Basing your labels on a query is a good idea for other reasons too. With a
query
you could print labels for certain groups of students by using criteria in
your
query. For example, you might only print labels for students in a certain
class,
who live in a certain dorm or who belong to a certain fraternity or
sorority.
You might even just want to print labels only for students over at 'Animal
House'! :)

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"DebbieG" <debbieg@access us-REMOVE-THIS-.net> wrote in message
news:vr******** ************@ac cessus.net...

I am creating a database for a small department in a university. Each
student in their database can have 2 mailing addresses. They wanted mailing labels pulling just the 1st address. No problem.

However, now they want a second label for students that have a second
mailing address.

Any ideas of how I can accomplish this?

Thanks in advance for any help.
Debbie

[Bradley]

Create one query to get Address1. Create another to get Address2...

....then create a Union query to merge the two lists.

SELECT * FROM Query1
UNION
SELECT & FROM Query2;

(Both queries myst return the same number of fields - but don't need to
be of the same data type though)

--
regards,

Bradley

DebbieG wrote:

I have a separate table for the addresses. I added the 2nd set of
addresses information to the query I am using for my labels. But how
do I create 2 separate labels for a student if they have information
in both addresses? Do I change the textboxes on my label report? If
so, how?

"Steve" <sp**@nospam.sp am> wrote in message
news:U0******** **********@news read2.news.atl. earthlink.net.. .
Your student table either has fields for two addresses or you have a
separate
address table. In either case, you need to create an appropriate
query that gets
the student names and the addresses you want. Your label is based on
this query.
Basing your labels on a query is a good idea for other reasons too.
With a query
you could print labels for certain groups of students by using
criteria in your
query. For example, you might only print labels for students in a
certain class,
who live in a certain dorm or who belong to a certain fraternity or
sorority.
You might even just want to print labels only for students over at
'Animal House'! :)
"DebbieG" <debbieg@access us-REMOVE-THIS-.net> wrote in message
news:vr******** ************@ac cessus.net...

I am creating a database for a small department in a university.
Each student in their database can have 2 mailing addresses. They
wanted mailing labels pulling just the 1st address. No problem.

However, now they want a second label for students that have a second
mailing address.

Any ideas of how I can accomplish this?

Thanks in advance for any help.
Debbie

--
regards,

Bradley

[PC Datasheet]

Bradley's idea is good if you want to print labels for both addresses in the
same print session. I recommend that you place an option group on the form where
you launch the labels. The option group to have the vaue Address1, Address2,
Both. You can then select what you want to print before you start printing. If
you want to have other criteria fields in your query for seecting who to print
labels (Like The Animal House), you can put those criteria fields on your launch
form too. Then all you need is a query that uses the option group and any other
criteria fields to return who you want to print labels for in the upcoming print
session.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"DebbieG" <debbieg@access us-REMOVE-THIS-.net> wrote in message
news:59******** ************@ac cessus.net...

I have a separate table for the addresses. I added the 2nd set of addresses
information to the query I am using for my labels. But how do I create 2
separate labels for a student if they have information in both addresses?
Do I change the textboxes on my label report? If so, how?

"Steve" <sp**@nospam.sp am> wrote in message
news:U0******** **********@news read2.news.atl. earthlink.net.. .
Your student table either has fields for two addresses or you have a
separate
address table. In either case, you need to create an appropriate query that
gets
the student names and the addresses you want. Your label is based on this
query.
Basing your labels on a query is a good idea for other reasons too. With a
query
you could print labels for certain groups of students by using criteria in
your
query. For example, you might only print labels for students in a certain
class,
who live in a certain dorm or who belong to a certain fraternity or
sorority.
You might even just want to print labels only for students over at 'Animal
House'! :)

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"DebbieG" <debbieg@access us-REMOVE-THIS-.net> wrote in message
news:vr******** ************@ac cessus.net...

I am creating a database for a small department in a university. Each
student in their database can have 2 mailing addresses. They wanted

mailing

labels pulling just the 1st address. No problem.

However, now they want a second label for students that have a second
mailing address.

Any ideas of how I can accomplish this?

Thanks in advance for any help.
Debbie

[DebbieG]

This worked like a charm! Thank you so much for helping me.

Debbie
"Bradley" <br*****@REMOVE THIScomcen.com. au> wrote in message
news:40******** @nexus.comcen.c om.au...
Create one query to get Address1. Create another to get Address2...

....then create a Union query to merge the two lists.

SELECT * FROM Query1
UNION
SELECT & FROM Query2;

(Both queries myst return the same number of fields - but don't need to
be of the same data type though)

--
regards,

Bradley

DebbieG wrote:

I have a separate table for the addresses. I added the 2nd set of
addresses information to the query I am using for my labels. But how
do I create 2 separate labels for a student if they have information
in both addresses? Do I change the textboxes on my label report? If
so, how?

"Steve" <sp**@nospam.sp am> wrote in message
news:U0******** **********@news read2.news.atl. earthlink.net.. .
Your student table either has fields for two addresses or you have a
separate
address table. In either case, you need to create an appropriate
query that gets
the student names and the addresses you want. Your label is based on
this query.
Basing your labels on a query is a good idea for other reasons too.
With a query
you could print labels for certain groups of students by using
criteria in your
query. For example, you might only print labels for students in a
certain class,
who live in a certain dorm or who belong to a certain fraternity or
sorority.
You might even just want to print labels only for students over at
'Animal House'! :)
"DebbieG" <debbieg@access us-REMOVE-THIS-.net> wrote in message
news:vr******** ************@ac cessus.net...

I am creating a database for a small department in a university.
Each student in their database can have 2 mailing addresses. They
wanted mailing labels pulling just the 1st address. No problem.

However, now they want a second label for students that have a second
mailing address.

Any ideas of how I can accomplish this?

Thanks in advance for any help.
Debbie

--
regards,

Bradley

[Bradley]

DebbieG wrote:

This worked like a charm! Thank you so much for helping me.

Debbie
I only rediscovered the 'ol Union query a little while ago... I was
doing it "old school" and creating a temporary table in which I dumped
the results of two (or more) queries :)
--
regards,

Bradley

"Bradley" <br*****@REMOVE THIScomcen.com. au> wrote in message
news:40******** @nexus.comcen.c om.au...
Create one query to get Address1. Create another to get Address2...

...then create a Union query to merge the two lists.

SELECT * FROM Query1
UNION
SELECT & FROM Query2;

(Both queries myst return the same number of fields - but don't need
to be of the same data type though)

--
regards,

Bradley

DebbieG wrote:

I have a separate table for the addresses. I added the 2nd set of
addresses information to the query I am using for my labels. But how
do I create 2 separate labels for a student if they have information
in both addresses? Do I change the textboxes on my label report? If
so, how?

"Steve" <sp**@nospam.sp am> wrote in message
news:U0******** **********@news read2.news.atl. earthlink.net.. .
Your student table either has fields for two addresses or you have a
separate
address table. In either case, you need to create an appropriate
query that gets
the student names and the addresses you want. Your label is based on
this query.
Basing your labels on a query is a good idea for other reasons too.
With a query
you could print labels for certain groups of students by using
criteria in your
query. For example, you might only print labels for students in a
certain class,
who live in a certain dorm or who belong to a certain fraternity or
sorority.
You might even just want to print labels only for students over at
'Animal House'! :)
"DebbieG" <debbieg@access us-REMOVE-THIS-.net> wrote in message
news:vr******** ************@ac cessus.net...

I am creating a database for a small department in a university.
Each student in their database can have 2 mailing addresses. They
wanted mailing labels pulling just the 1st address. No problem.

However, now they want a second label for students that have a
second mailing address.

Any ideas of how I can accomplish this?

Thanks in advance for any help.
Debbie

--
regards,

Bradley