Null Query Field

  • Thread starter Thread starter Brook
  • Start date Start date
B

Brook

Is there a way to set up a query so that if one field
is "Null" then the query doens't run?

I have a tblSpecialNotes table that has a CompanyID,
Company Name, and Notes Columns, and when I enter one of
my forms I want the query to run and if there is data in
the SpecialNotes column, the Query will appear on the
screen else if the SpecialNotes Column is Null then the
user sees nothing and the form just opens..

Any Ideas?

Brook
 
Brook,

Put this in the Criteria of the SpecialNotes field in the query...
Is Not Null
 
Try combination of:
IIf (NZ(Notes;"Empty")="Empty") then
Visible() = valse
else
visible() = true
endif

success
 
Back
Top