Q. query for space in several fields doesn't work ( =" " )

  • Thread starter Thread starter Jim Jones
  • Start date Start date
J

Jim Jones

Hi,

I need a query, where I will delete the record, if two certain fields
are equal to a space .

I can't get =" " to work.

I can delete if it's =0, but that's not what I need right now.

Can you help,

Thanks,
Jim
 
Are you sure they're equal to a space? ACCESS trims trailing spaces
automatically when it stores values, so a single-space text string will
store as an empty string in the table. Try searching for
=""
 
Back
Top