gabester
asked on
For wsh2
Wsh2...with the code you gave me...I need to query the date and service.
Below is the code I have
************************** ********** *
rsGet.Source _
= "SELECT DeliveryNumber, Weight, ZipCode, TrackingNumber, Zone " _
& "FROM Packages Where Service like 'Call*' Date = " & "#" & nDate & "#"
rsGet.Open
************************** **********
when I only search for the date..it works...but when I search for multiple it doesn't work...HELPPP
Below is the code I have
**************************
rsGet.Source _
= "SELECT DeliveryNumber, Weight, ZipCode, TrackingNumber, Zone " _
& "FROM Packages Where Service like 'Call*' Date = " & "#" & nDate & "#"
rsGet.Open
**************************
when I only search for the date..it works...but when I search for multiple it doesn't work...HELPPP
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER