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

gabesterAsked:
Who is Participating?
 
Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
rsGet.Source _
   = "SELECT DeliveryNumber, Weight, ZipCode, TrackingNumber, Zone " _
   & "FROM Packages Where Service like 'Call*' AND Date = #" & nDate & "#"
0
 
gabesterAuthor Commented:
Thanks emoreau...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.