I keep on getting a syntex error (comma) in query expression and I don't know why

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mattcibulka
    New Member
    • May 2021
    • 1

    I keep on getting a syntex error (comma) in query expression and I don't know why

    strSQL = "SELECT Origin, Destination, TransitTime, Cost FROM Shipments " _
    & "WHERE TransitTime >= " & TransitTimeFrom CB & _
    " AND TransitTime <= " & TransitTimeToCB & _
    " AND Destination = " & DestCB & _
    " AND Cost <= " & CostFromCB & _
    " AND Cost >= " & CostToCB & _
    " AND Origin = " & OriginCB
Working...