Filter Fields On Form

[jdebill]

Hi All,

I was trying to set a filter on PTC on a view of the F4201 table to data select on = 03, 14, and AA. It didn't work as the SQL statement looked like it was a series of "PTC = "03" AND PTC = "14" AND PTC = "AA" so no records were returned. So how do you filter for a set of specific values like this?
Any help will be appreciated.

Thanks in Advance,

Thank You,
Bill
Windows NT, SQL 7, XE 13.0

 

[tom_brown]

you could use the system funtion 'Set User Selection'(I think thats what its
called!), rather than using filter fields. This should let you specify 'OR'
statements which should give you what you need...

Hope this helps

Tom Brown