Hi guys,
Im trying to update a main table with the below code
Code:
DoCmd.RunSQL "INSERT INTO PackageDetails_tbl ([Item], [Qty], [Description], [DeliveryNoteNumber]) VALUES (TempPackageDetails_tbl.Item, TempPackageDetails_tbl.QTY, TempPackageDetails_tbl.Description", " & DbNoteNumber & )"
The only 2 values which are numbers are TempPackageDetails_tbl.QTY and & DbNoteNumber & (which I thought have been identified correctly?) but Im getting an error stating that an expressionb you entered is the wrong data type for one of the arguements - any ideas please?