Ms Access Query

[dsb777]

hi, ive been using vg to connect to a microsoft access database and if caller enters an mls #, it will search that field and if it finds the number then it will read back the phone number associated with that record...

 

heres what Im using and it works...

SELECT PhoneNumber FROM Listings WHERE MLS='$RV[GetMLSNumber]'

 

but was wondering if anyone knew how to allow me to search two or more fields for the submitted #?

 

because some records have 3 MLS #'s... so was hoping i could have 3 seperate fields (MLS, MLS2, MLS3) and if my query doesnt find the number in mls field, it will then search the mls2 field, etc...

 

 

i keep trying to put an "or" but its not working....

 

any help would be appreciated. thanks

[dsb777]

ok never mind about this one... delete this thread if possible.. LOL I wasted your time.

 

: )