Null Value in Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a Like Forms!myForm!cmbMyBox in query to get data based on what is
in cmbMyBox. If the user leaves it blank the cmbMyBox defaults to * which
returns all records. So it was working good until I found some records in
the table that have blanks in the column that cmbMyBox references. Those
records are not returned by my query in * mode.

I cannot modify the table to make the value required because it is not mine,
it is a linked table from another program. Does anyone have a slick way out
of this jam?
 
Add a field/column in your query like:
Field: NewField: [MyField] & ""
Criteria: Like Forms!myForm!cmbMyBox
 
Back
Top