QBE and Derived Fields

[JVasser]

I have a field in a query that is a compound concatenation to form a person's name in the form of "LastName, FirstName MiddleName". When I try to include this field in the QBE definition, I get an error that indicates I should set the Origin property of the field.

What can I use in the Origin property to make the field queryable?

 

[Marco Kalter]

You should specify the exact SQL expression for this calculated field, for example:

LastName | | ', ' | | FirstName | | ' ' | | MiddleName

This expression will be used in the where clause.

------------------
Marco Kalter
Allround Automations

 

[JVasser]

That took care of it. Thanks!