querying selected data from multiple tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Collette - 15 Jun 2006 13:49 GMT

I want to create a form letter in mail merge using Access. How can I select
specific data to print?

I have a table of companies with their addresses and a separate table of
contacts that I queried. There can be many contacts for one company, but I
only want certain contacts (1 per company) to print. What criteria would I
use to choose a random group of people (about 150 total)?

Signature

Collette

Reply to this Message

Jeff C - 15 Jun 2006 20:02 GMT

Try this link for a great tutorial in FLASH.

http://www.datapigtechnologies.com/AccessMain.htm

look for the title "create form letters with and without mail merge".

Signature

Jeff C
Live Well .. Be Happy In All You Do

> I want to create a form letter in mail merge using Access. How can I select
> specific data to print?
[quoted text clipped - 3 lines]
> only want certain contacts (1 per company) to print. What criteria would I
> use to choose a random group of people (about 150 total)?

Reply to this Message

Collette - 15 Jun 2006 20:37 GMT

I'll take a look at it - thanks.

Signature

Collette

> Try this link for a great tutorial in FLASH.
>
[quoted text clipped - 9 lines]
> > only want certain contacts (1 per company) to print. What criteria would I
> > use to choose a random group of people (about 150 total)?

Reply to this Message