Query - String Fields NOT Empty Condition

T

Tecknomage

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?!
 
F

fredg

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?!

Not ""
 
Top