Shouldn't this work? 1

[Golding]

Is there another way to write this so it works?

SQL = ("SELECT * FROM members WHERE act = 'active' AND pr_agent2 OR pr_agent =" & agn)

Basically the agn is a request defined earlier, that part is working. It seems to be the 'pr_agent2 OR pr_agent' part thats not doing what it should.

Any ideas?

Thanx

 

[scriverb]

give this a try:

SQL = ("SELECT * FROM members WHERE act = 'active' AND (pr_agent2 =" & agn & " OR pr_agent =" & agn))


Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[Golding]

Although that didn't work, it pointed me in the right direction, this is what eventually worked..
SQL = ("SELECT * FROM members WHERE act = 'active' AND pr_agent2 =" & agn & " OR act = 'active' AND pr_agent =" & agn)

Thanks very much