Ive reworded my question in the hope i may get a solution, hopefully this is clearer than the last

I have 3 tables

1 is 'Company' (Fields = Co Name, Addr1, Addr2, Tel, Fax etc)

2 is 'Contacts' (1 Company to many Contacts relationship) (Fields = Co Name, Contact ID, Surname, First Name, Title etc)

3 is 'Enquiries' (1 Contact to many enquiries relationship) (Fields = Contact ID, Advert Type, Advert Code, Journal, Product,)

The info for Advert Code and Product comes from look up tables.

The Advert Code choices are
Project Bulletin (P)
Advert (A)
Telephone (T)
Email (E)
Freefone (F)

The Product Group choices is upto twenty different product ranges ie. 'MICROPUMP' 'ENCYNOVA', 'THOMPSON', 'NIKKISO'

The information i want to gather is
Company Name, Plus Address, Contact Name plus title, tel no, fax no, the date they enquired, the product enquired about, the journal they saw it in.

I dont want to include any records if the advert code is P, T or F

I want ALL records that are advert code A

I only want advert code E if the product is NOT 'Micropump' 'Encynova' or 'FMI'

OR to put this another way, I only want advert code E if the product group is one of the other 17 product choices

I hope this helps

Look forward to receiving your reply

Thanks alot

Jane