473,324 Members | 2,501 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Labels: 1 person, 2 addresses

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
6 2070
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Fred | last post by:
Hi. Sorry, but I don't know where else to ask. I wrote a access shipping database and we currently use the web interface for DHL to print shipping labels. That means we have to manualy transpose...
6
by: DebbieG | last post by:
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....
2
by: John Smith | last post by:
Perhaps the wrong place to ask but...Friend has names and addresses in Microsoft Works Database...how can she print off address labels from this database? Thanks, John
10
by: John Baker | last post by:
Hi: I have a user who has labels that are set up 3 across and 11 vertical (which is unusual at best), and he wants me to print names and addresses on them. I have already set up for labels 10...
1
by: Ravimama | last post by:
Hi Guys, I have to generate mailing labels for selected addresses using crystal reports. I am loading all the names of the vendors in a checked list box. the user will select a few of the...
1
by: Jamie J. Begin | last post by:
I'm very new to the world of Python and am trying to wrap my head around it's OOP model. Much of my OOP experience comes from VB.Net, which is very different. Let's say I wanted to create an...
0
by: xikom01 | last post by:
In this age, there is a lot of focus on the importance of "getting organized." There are even professional organizers for hire! Labels are a huge presence in the field of organization, because they...
55
by: aarklon | last post by:
Hi, why general integer expressions are not allowed in case labels in switch statements..????
2
by: divyac | last post by:
I have developed an address book using php and mysql.I have all the contacts list in a table with check boxes.Now that i want to create mailing labels for the checked contacts...i.e.,the arrangements...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.