OK one little hickup.
This query leaves the fields where it does not find [4Shipment
Detail]![Dilivery note Detail ID] = " & [2Deliv note detail]![Deliv note
detail ID] blank.
It must where[4Shipment Detail]![Dilivery note Detail ID] <> " & [2Deliv
note detail]![Deliv note detail ID],[2Deliv note detail]![Delivered
Cartons]-0. Where did I go wrong now again.
UPDATE [2Deliv note detail] SET [2Deliv note detail].[Cartons Remaining] =
[2Deliv note detail]![Delivered Cartons]-DSum("[Shipped Cartons] ","4Shipment
Detail"," [4Shipment Detail]![Dilivery note Detail ID] = " & [2Deliv note
detail]![Deliv note detail ID]);
Thanks
Ofer said:
Any time
Esrei said:
Thanks a mil works!!!!!!!!!!!
:
Look at the input box for the parameter, on top it should display the field
it can't find.
In the query you use the [4Shipment Detail]![Shipped Cartons], I think it
should be
[2Deliv note detail]![Shipped Cartons], because you dont have the 4Shipment
Detail table in the query.
:
The query runs without any error messages now but the field is not updated?
It does ask me for parameter values and I just ok? Thanks so far.
UPDATE [2Deliv note detail] SET [2Deliv note detail].[Cartons Remaining] =
[4Shipment Detail]![Shipped Cartons]-DSum("[Shipped Cartons] ","4Shipment
Detail"," [4Shipment Detail]![Dilivery note Detail ID] = " & [2Deliv note
detail]![Deliv note detail ID]);
:
The Dsum should be written like that
DSum("[Shipped Cartons] ","4Shipment Detail"," [4Shipment Detail]![Dilivery
note Detail ID] = " & [2Deliv note detail]![Deliv note detail ID])
If it doesn't help then please post the all SQL.
:
What is wrong with this formula I am trying to make a updat query but it dont
want to work.
The update must add the cartons in 4shipmentdetail table where the Deilvery
note detail ID is the same.
DSum("[Shipped Cartons] ","4Shipment Detail"," [4Shipment Detail]![Dilivery
note Detail ID] = & [2Deliv note detail]![Deliv note detail ID]")
