Problem with a Query please help

[winterh]

Hi All



I hope you can help, if i explain what i have and what I need, and hope youwill be able to come up with some ideas.

I have five columns within one table and each column has the same drop downlist of users, eg Had,Emma,John

I want to run a query which will display all the columns with "hads"in, I understand I can add a criteria within the query eg "hads" butthe problem I have if I add the same criteria within the other columns it willnot display any data.

I understand way because the criteria is looking at each column and will onlydisplay "hads" but within column one it may say "hads" butin column two it may say "Emma" but I want to see every field with"hads" in as in some cases he may be in column one and next record hemaybe in column two and Emma maybe in Column two.

I hope this makes some sense.

[R_Badger]

You need to use OR criteria you appear to be using AND

The SQL would look something like

SELECT * FROM Tablename WHERE Column1="Had" OR Column2="Had" OR Column3="Had" OR Column4="Had" OR Column5="Had"

If using the access query builder (only really used 2003 here) then across is and, down is or

Hope that makes sense

[winterh]

Thanks mate, worked like a dream :-)