Merging word document with Access query

[Emma@KH]

Apologies ... but I am quite new to Access. My database contains about 1000 peoples' addresses.

The problem I have is that I need to merge, say, 20 of these addresses into a word document. In the word document I can select records using the "Surname" field but it will not give me the option to select more than 6.
I am sure there must be a way that I can select more than 6: I have tried separating the surnames with a "," or "or" but nothing seems to work!

Help, please!

Thank you,

Emma

 

[alastair69]

Emma,
You say more then six is this more then six peoples sure names?

 

[Emma@KH]

Alastair,

Yes ... I need to select more than six peoples' details to merge into a word document and am using the "surname" field to select the details I need. I am using "equal to" in the query option in Word but it will not give me the opportunity to select more than six. Hope you can help!?!

Thanks,

Emma

 

[Idris]

You got to create another column/field say Iprint with a value of 0

Fill the column (Iprint) with 0 value and then select as many as you want by changing it to 1 or any number of your choice

now you can query the column to print/merge all dcoument that not equal to 0

hope this help