how to select individual records in database to print selected lab

T

Terri

I have a database of names and addresses which I use to print labels for xmas
cards. I don't want to send to everybody but select each individually. How
do I do this?
 
J

John W. Vinson

I have a database of names and addresses which I use to print labels for xmas
cards. I don't want to send to everybody but select each individually. How
do I do this?

One way is to add a new field to the table of names. This could be a Yes/No
field (called PrintMe for example); base your labels report on a Query
selecting True as the criterion on this field (after checking the people
who'll get late cards <g>).

Another way would be to add a new table, SentYear, with fields for a link to
the primary key of the names table and a year. You could fill this (using a
form with combo box) with the ID's of the recipients and the year - you'ld
then use a query with a criterion of 2008 on a join of this table to the names
table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top