multiple statement in WHERE clause

[davyre]

updateQry = "UPDATE QryOrderUnitID " _
         &  "SET QtyOrdered=" & updQtyOrdered & ", ETD=#" & updEtd & "#, UnitDeliveryDate=#" & updUdd & "#, Status=" & updStats _
         &  " WHERE OrderID=" & updOrderID & ", UnitID=" & updUnitID

I need to write WHERE clause where it matches up those two values, but I seems got a syntax error.
I prefer using AND expression, but it gave me error Type Mismatch. Anyone can help? Thanks

 

[dhookom]

Type Mismatch suggests you probably have a string field that you are treating as numeric. If there are no text/string fields then this should work:

updateQry = "UPDATE QryOrderUnitID " _
         &  "SET QtyOrdered=" & updQtyOrdered & ", ETD=#" & updEtd _
         &  "#, UnitDeliveryDate=#" & updUdd & "#, Status=" & updStats _
         &  " WHERE OrderID=" & updOrderID & " AND UnitID=" & updUnitID

All of this assumes qryOrderUnitID is updateable.

Duane
Hook'D on Access
MS Access MVP

 

[davyre]

yeah that works! Thanks