Zero String? I cant figure out what is in these blank looking cells.

[knowshowrosegrows]

I have a table that was imported from an excel document that I did not create. I made the fields Enrolled and Withdrawn so they would not accept zero string but I'll be damned if I can figure out what is in the blank looking cells. Please help. I'm sure it is something obvious.

Thanks so much.

[ranman256]

dont import nulls, nor empty strings.

[June7]

They have empty string. At least a query set to filter for "" returns records. I had to build another query, couldn't get yours to work.

I tried to replicate issue by first exporting your table to a text file then importing to new records. The new records have Nulls.

[knowshowrosegrows]

Thanks so much. How do I remove the "" from the cells?

[knowshowrosegrows]

Thanks so much for your insightful reply. Can you tell me how I keep from importing nulls or empty strings.

Thanks so much.

[June7]

An UPDATE action:

UPDATE CMHCRosterForTest SET CMHCRosterForTest.Withdrawn = IIf([Withdrawn]="",Null,[Withdrawn]), CMHCRosterForTest.Enrolled = IIf([Enrolled]="",Null,[Enrolled]);

Or do you want to delete all the records that have empty string or Null in both fields?

Not sure how to prevent the empty strings during import. Provide text file for testing.

[knowshowrosegrows]

Thank you so much!