Selecting individual records for a report

J

JDB

I have a table with 200+ contacts. I want to generate letters to 7-8 of
them, but there is no common criteria upon which I can run a query.

I'd like to create the letters, then when the report is run be able to
select which records from the table receive the letter. No idea how to go
about this (other than exporting to excel, deleting non-receivers, and doing
a Word mailmerge).

Suggestions?
 
D

Duane Hookom

If there truly is no relationship, you could create a new table of records to
report with a single field that is the primary key of you contacts table. Add
or delete records from this reporting table and join it to the contacts
table. Only those primary key values in the reporting table will display in
the report.
 

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