please help query

[dj_luna]

I am busy with a database that tracks new candidates. I have a table with 4 fields position applied for 1,2,3 and 4 for every candidate. Based on this table I have a query with 1 field, position applied for. How do I get the query to search my input in this 1 field from all 4 fields in 1table.



E.g Joe smith is applying for a jon as a builder or a driver or a shop assistant or fisherman. Now I would like to. Search against that 4 options from 1 field in my form. Query should return with the relevant info depending on my search criteria.

I appreciate your assistance. I am a newbie but not tolly useless. I am using ms access 2010 64bit

[recyan]

Just check out if below gives some guidelines :

SELECT 
    tblCandidates.txtName, 
    tblCandidates.Position1, 
    tblCandidates.Position2, 
    tblCandidates.Position3, 
    tblCandidates.Position4
FROM 
    tblCandidates
WHERE 
    (((tblCandidates.Position1)=Forms!frmGetCandidates!PositionSearchedFor)) 
    Or 
    (((tblCandidates.Position2)=Forms!frmGetCandidates!PositionSearchedFor)) 
    Or 
    (((tblCandidates.Position3)=Forms!frmGetCandidates!PositionSearchedFor)) 
    Or 
    (((tblCandidates.Position4)=Forms!frmGetCandidates!PositionSearchedFor));

Thanks