Selecting individual records for a report

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?

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.

--
Duane Hookom
Microsoft Access MVP


"JDB" wrote:

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?

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.

--
Duane Hookom
Microsoft Access MVP


"JDB" wrote:

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?

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.

--
Duane Hookom
Microsoft Access MVP


"JDB" wrote:

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?