Return records with text v/s no text in field. (1 Viewer)

[ktariske]

I need to get records returned in a query with something in the comments column. In other words, return only records that have something in the column. I tried <>"" but that returns a SQL error.

Thanks.

 

[Jerry Stoner]

Try Is Not Null

 

[ktariske]

Thanks, that worked. Wow, this board is sweet.

 

[Jerry Stoner]

welcome