Filter criteria

[martinbarnes]

Question:

I built a query that filters data from two fields (I'll call them Field #1
and Field #2)in a table. Field #1 contains one of three entries ("a", "b",
or "c" for simplicity's sake), and Field #2 contains subsequent, amended
entries to Field #1. If there was no amendment then the entry is blank in
Field #2. My query filtered for all "a" entries found in either of the two
fields. Now that I've got those filtered out, I need to create a report or
table that displays only Field #1 "a" entries if there is no amended entry in
Field #2, and only Field #2 "a" entries if there was a subsequent amendment.

Any suggestions? I'd be grateful to anyone who can provide an answer to my
convoluted question...

 

[Valentín Playá]

Martin,

I believe it will be easier if the query does the selection. Your
restrictions in the query should be (Field 1 = "a" and isnull(Field 2)
OR (Field 2 = "a").

If you use the query grid place the first two restrictions in the same
line a the third in line 2 of the grip.

Regards,

Valentín Playá
Sonotronic S.A.
Madrid, Spain
************************************************************************************