Combining tables with multiple entries, sort for mailing list

[jmcneary]

I hope this is not too basic for this forum ... but here goes.

I have linked two tables and have multiple entries (8000) for many customers. I want to sort so that each customer comes up only one time so I can generate mailing lables for certain types of work.

At present, some customers show in the query 6 to ten times and I want to fix it so that I can have each customer who is selected only show up one time.

Greatly appreciate any help.

jack mcneary

 

[MTGMAN64]

Before I can help you can you please let me know what field names you are using in both tables. Also be more specific as to what sort of data you need as output.

 

[huzza]

Depending on what exactly you want you could use something like the following sql

select distinct [customer name],[customer address]
from customer
where [work type] = [required type]

If you can post more details of what you require and how your tables are laid out I will be able to customise this for your needs.
Richard