Bit of a odd Queries

[winterh]

I have four columns which a user can add one of four names, I have done an example below for you to look over.



Column1 Column2 Column3 Columns4 ID
John John Peter 1
Peter John Simon Peter 2

What I want is to see the information which to do with "john" so in the query, under Criteria in Column1 i added "john" but if i would do the same in coloum2 3 and 4 it would not return any information.

So I guess I need something like "John" Or If Null (I know this is not right)

Sorry not to clear but hope this make some sense.

[pbaldy]

For starters, you data is probably not normalized if you have 4 fields the name could be in. That said, if you put the criteria for each field on a different line in design view, that creates an "OR" instead of "AND" comparison.

[winterh]

I will try it, I have worked a long winded work around where I run a query for each name on each column but as you understand is giving loads of work.