I have a table with a number of fields the main ones for this query are:-

"ProjectStatus" (combo box)

"FeeQuoteSent" (check box)
"InstructionLetter" (check box)
"ProjectForm" (check box)
"RiskAssesment" (check box)

I would like to find all records which do not have a check in any one of the boxes but also matches one of four choices from the combo box.

For some reason I can't get both parts to work correctly.

I have a table with a number of fields the main ones for this query are:-

"ProjectStatus" (combo box)

"FeeQuoteSent" (check box)
"InstructionLetter" (check box)
"ProjectForm" (check box)
"RiskAssesment" (check box)


Basically:

[Forms]![MyForm]![MyCombo] for the criteria on the combobox field (on all 4 lines)

And then, one for each line

Checkbox1 OR Checkbox2 OR Checkbox3 OR Checkbox4


May I suggest that, rather than use checkboxes, you may find it beneficial to store dates instead for fields such as FeeQuoteSent. ;)

Thats great thanks and works fine.

Will have a think about dates instead of check boxes.

Karen