Select records for merging into word document.

[Guest]

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?

 

[Jeff Boyce]

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>

 

[nChicago]

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

 

[Jeff Boyce]

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.