By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 1,478 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Labels: 1 person, 2 addresses

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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******@pcdatasheet.com
www.pcdatasheet.com
"DebbieG" <debbieg@accessus-REMOVE-THIS-.net> wrote in message
news:vr********************@accessus.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

Nov 12 '05 #2

P: n/a
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.spam> wrote in message
news:U0******************@newsread2.news.atl.earth link.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******@pcdatasheet.com
www.pcdatasheet.com
"DebbieG" <debbieg@accessus-REMOVE-THIS-.net> wrote in message
news:vr********************@accessus.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

Nov 12 '05 #3

P: n/a
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.spam> wrote in message
news:U0******************@newsread2.news.atl.earth link.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@accessus-REMOVE-THIS-.net> wrote in message
news:vr********************@accessus.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
Nov 12 '05 #4

P: n/a
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******@pcdatasheet.com
www.pcdatasheet.com
"DebbieG" <debbieg@accessus-REMOVE-THIS-.net> wrote in message
news:59********************@accessus.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.spam> wrote in message
news:U0******************@newsread2.news.atl.earth link.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******@pcdatasheet.com
www.pcdatasheet.com
"DebbieG" <debbieg@accessus-REMOVE-THIS-.net> wrote in message
news:vr********************@accessus.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


Nov 12 '05 #5

P: n/a
This worked like a charm! Thank you so much for helping me.

Debbie
"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:40********@nexus.comcen.com.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.spam> wrote in message
news:U0******************@newsread2.news.atl.earth link.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@accessus-REMOVE-THIS-.net> wrote in message
news:vr********************@accessus.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
Nov 12 '05 #6

P: n/a
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*****@REMOVETHIScomcen.com.au> wrote in message
news:40********@nexus.comcen.com.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.spam> wrote in message
news:U0******************@newsread2.news.atl.earth link.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@accessus-REMOVE-THIS-.net> wrote in message
news:vr********************@accessus.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
Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.