query displays blank fields

[AWilderbeast]

I have a query that gets data from a table now not all fields are filled in, in this table, and the query only shows data that has all fields filled and i need it to show them all

 

[RuralGuy]

Please post the SQL view for your query so we can review it.

 

[AWilderbeast]

Heres an image

Heres the sql view

SELECT TblRecruits.cl_fname, TblRecruits.cl_sname, TblRecSkill.[Primary Skill], TblRecruits.rec_id, TblRecSkill.[Secondary Skill], TblRecSkill.[Specialist Skill]
FROM TblRecruits INNER JOIN TblRecSkill ON TblRecruits.rec_id = TblRecSkill.Rec_ID
WHERE (((TblRecruits.cl_sname) Like [Forms]![MainListRecTrades2nd]![txtSearchBox2] & "*") AND ((TblRecSkill.[Primary Skill]) Like [Forms]![MainListRecTrades2nd]![txtSearchBox] & "*") AND ((TblRecSkill.[Secondary Skill]) Like [Forms]![MainListRecTrades2nd]![txtSearchBox3] & "*") AND ((TblRecSkill.[Specialist Skill]) Like [Forms]![MainListRecTrades2nd]![txtSearchBox4] & "*"))
ORDER BY TblRecruits.cl_sname;

 

[EMP]

In query design, put the criteria for each field in a separate column like this:-
=================================
Field: [TblRecruits].[cl_sname] Like [Forms]![MainListRecTrades2nd]![txtSearchBox2] & "*" OR [Forms]![MainListRecTrades2nd]![txtSearchBox2] Is Null

Show: uncheck

Criteria: True
=================================

See Jon's sample in this thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=103312

^