If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Selecting individual records for a report
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? |
#3
|
|||
|
|||
Selecting individual records for a report
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? |
#4
|
|||
|
|||
Selecting individual records for a report
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? |
Thread Tools | |
Display Modes | |
|
|