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
resource@pcdatasheet.com www.pcdatasheet.com
"DebbieG" <debbieg@accessus-REMOVE-THIS-.net> wrote in message
news:59OdndHLj5Pk7RrdRVn-gg@accessus.net...[color=blue]
> 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" <spam@nospam.spam> wrote in message
> news:U0Khc.18322$l75.4376@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
>
resource@pcdatasheet.com
>
www.pcdatasheet.com
>
>
> "DebbieG" <debbieg@accessus-REMOVE-THIS-.net> wrote in message
> news:vrydnYU9eJbs-xrdRVn-ig@accessus.net...[color=green]
> > I am creating a database for a small department in a university. Each
> > student in their database can have 2 mailing addresses. They wanted[/color]
> mailing[color=green]
> > 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
> >[/color]
>
>[/color]
