Hi everyone,

I have created a simple query based on one table in the QBD grid.

The query returns records for the following fields: [DepartmentCode], [DepartmentName],[ActivityCode], [Activity Name], and [Cost].

I have specified the following criteria, on the [ActivityCode] field - "like 61* or like 64* or like 66* or like 68* or like 69* or like 8*", to limit the records returned.

Here is what I am having trouble accomplishing:

When [ActivityCode] is like 8*, I want all values for [DepartmentCode] returned, but when [ActivityCode] is anything else, I want to eliminate those [DeptUnit] records that are like 19*, 9*, and 8*.

Please let me know if you need additional info.

Thanks in advance for your help.

Anlon

Welcome to P2P, Anlon.

On your criteria grid in the query, the first row should be like 8* in the [ActivityCode]. On the second row, you should have

Not like 8* (in [ActivityCode])
Like 19* or Like 9* or Like 8* (in [DeptUnit])


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thank you very much for your help. Works perfectly.

Anlon