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