Access 2007 query for a Character or no value
Posted on 2011-03-18
I'm trying to query and database field to show if it has and asterisk (*) as the first character or if the field is blank. Below are 2 examples that I've tried. If I just use the first part I can query out fields that have the *, but I can't get just blank fields to show up. The examples just give me everything.
Trap6: (InStr(1,[CellBock6],Chr(42)) Or Len([CellBock6])=0)
Trap7: (InStr(1,[CellBock7],"*") Or (Len([CellBock7])=0))