Select records for merging into word document.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lopezn - 20 May 2005 01:19 GMT

I have a table of 66 records. I have a form letter which I have to send to
only 20 of those records. How do I select just the 20 records I need to
merge?

Reply to this Message

Jeff Boyce - 20 May 2005 03:05 GMT

If you had the list of 66 records in front of you, how would you pick the 20
out? Unless you have a way to tell which ones (e.g., every record with a
datefield value greater than today, all those with a "Yes" in the
?SendThisOne field, ...), no person, let alone Access, could figure it out.

Good luck

Jeff Boyce
<Access MVP>

> I have a table of 66 records. I have a form letter which I have to send to
> only 20 of those records. How do I select just the 20 records I need to
> merge?

Reply to this Message

nChicago - 20 May 2005 03:11 GMT

Hi.
I'm just a beginner, but I think you would use Access to create a Query that
would specify which records you are interested in.
Then you would create the report (I think the report wizard will let you
base the report on the query).

Good luck.

N

> If you had the list of 66 records in front of you, how would you pick the
> 20
[quoted text clipped - 12 lines]
>> only 20 of those records. How do I select just the 20 records I need to
>> merge?

Reply to this Message

Jeff Boyce - 20 May 2005 13:11 GMT

I think you and I just said the same thing, different words.

Unless there are some characteristics by which you can use a query to pick
out the 20, you won't be able to tell a person (or Access) how to pick out
the twenty.

Signature

Good luck

Jeff Boyce
<Access MVP>

> Hi.
> I'm just a beginner, but I think you would use Access to create a Query that
[quoted text clipped - 22 lines]
> >> only 20 of those records. How do I select just the 20 records I need to
> >> merge?

Reply to this Message