MS Access 2000

[rpj]

I need a way to select individual records to print as mailing labels. They would be records that don't necessarily have any criteria in common to use the "and", "or", etc. Any help is appreciated. I have the "report mailing label" set up, but keep getting the entire database printed even when I try to select specific ones using the datasheet format of the table. Thanks.

Pat

[Paul Komski]

Create a select query with the criteria you require and base the labelling report on that query.

An example to paste into the SQL statement (modified as necessary)

SELECT AddressBook.*, AddressBook.Country
FROM AddressBook
WHERE (((AddressBook.Country)="France"));

You could also add a field to your list of names, addresses, etc which is just a yes/no field called something like Selected. You could then select just the records you want to use by checking the box for these records and create a query that only allows these checked records.

SELECT AddressBook.*, AddressBook.Selected
FROM AddressBook
WHERE (((AddressBook.Selected)=True));

When printing - avoid clicking the printer icon which by default will print all records. Choose print from the file menu and choose to print pages 3 to 3, 2 to 6, (etc, etc).

[rpj]

Thanks Paul,

That's what I was thinking--on creatomg a "select" field.

Pat