:confused: I want to create a report based on a query. One field in the query is a combo box (TYPE) with the following information. A = ADVERT, P = PRESS RELEASE, E = EMAIL.

Another field in the query is a combo box linked to a product group table, examples in box are 'MICROPUMP', 'THOMPSON', 'ENCYNOVA', 'FMI' 'NONSEAL' (there are about twenty products in total)

I want to create a report that includes all records that have Type = 'ADVERT'(PLUS ANY PRODUCT)

no records at all where Type = 'PRESS RELEASE' and

only include type = 'EMAIL' if the product is not 'MICROPUMP', or 'ENCYNOVA' or 'FMI' (ie. 1 of the other 17 products)

Please help

Many thanks

Regards

Jane