Query - String Fields NOT Empty Condition

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

Guest

The Access Builder Tool let me build the following condition...

= ( [PSGW-Orders1]![Config1] ) And ( [PSGW-Orders1]![Config1] Not = "" )

....but when I try to copy this I get an expression error on Not = ""

1) OK, if I do not want returns when [Config1] is empty string, what is the
correct expression?

2) What good is the Build Tool if it allows incorrect phrasing?!
 
The Access Builder Tool let me build the following condition...

= ( [PSGW-Orders1]![Config1] ) And ( [PSGW-Orders1]![Config1] Not = "" )

...but when I try to copy this I get an expression error on Not = ""

1) OK, if I do not want returns when [Config1] is empty string, what is the
correct expression?

2) What good is the Build Tool if it allows incorrect phrasing?!
Click to expand...

Not ""
 
Back
Top