Query Help please!!

[AndyShuter]

In my query grid I have the following expression


Like "*" & [Forms]![frmLogEntry]![Combo442] & [Forms]![frmLogEntry]![Text75] & [Forms]![frmLogEntry]![Text77] & [Forms]![frmLogEntry]![Text78] & [Forms]![frmLogEntry]![Text79] & [Forms]![frmLogEntry]![Text80] & [Forms]![frmLogEntry]![Text81] & [Forms]![frmLogEntry]![Text82] & [Forms]![frmLogEntry]![Text83] &"*"

What I would like to do is run the query on either 1 or many of the selected fields, but all if there are no entries

Think I need the OR operand, but dont know where to put it!

Thanks

 

[llkhoutx]

Like "*" & [Forms]![frmLogEntry]![Combo442] & "*"
OR LIKE "*" & [Forms]![frmLogEntry]![Text75] & "*"
OR LIKE "*" & [Forms]![frmLogEntry]![Text77] & "*"
OR LIKE "*" & [Forms]![frmLogEntry]![Text78] & "*"
OR LIKE "*" & [Forms]![frmLogEntry]![Text79] & "*"
OR LIKE "*" & [Forms]![frmLogEntry]![Text80] & "*"
OR LIKE "*" & [Forms]![frmLogEntry]![Text81] & "*"
OR LIKE "*" & [Forms]![frmLogEntry]![Text82] & "*"
OR LIKE "*" & [Forms]![frmLogEntry]![Text83] &"*"

 

[AndyShuter]

Thanks

Thanks Buddy!