• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Filter Fields On Form

jdebill

Active Member
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

Active Member
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
 
Top