Hi,
I have an Append query named "Append Manifest" which I call using the DoCmd.OpenQuery "AppendManifest", acNormal, acEdit
INSERT INTO tblManifest ( DeliveryDocketID, DeliveryDocketNo, JobID, BatchNo, Quantity, QtyType, LabelCount, NumPallets, Status, Description )
SELECT JobsDeliveryVendor.DeliveryDocketID, JobsDeliveryVendor.DeliveryDocketNo, JobsDeliveryVendor.JobID, JobsDeliveryVendor.BatchNo, JobsDeliveryVendor.Quantity, JobsDeliveryVendor.QtyType, JobsDeliveryVendor.LabelCount, JobsDeliveryVendor.NumPallets, JobsDeliveryVendor.Status, JobsDeliveryVendor.[Material Description]
FROM JobsDeliveryVendor, tblNums
WHERE (((JobsDeliveryVendor.JobID)=[Forms]![Jobs]![JobID]) AND ((JobsDeliveryVendor.Status)>"0") AND ((tblNums.ID)<=[NumPallets]));
I am a newbie to the DoCmd.RunSQL but I would like to try and call the above using the
DoCmd.RunSQL. Could anyone point me in the direction on how to perform this?
Thanks for the help
I have an Append query named "Append Manifest" which I call using the DoCmd.OpenQuery "AppendManifest", acNormal, acEdit
INSERT INTO tblManifest ( DeliveryDocketID, DeliveryDocketNo, JobID, BatchNo, Quantity, QtyType, LabelCount, NumPallets, Status, Description )
SELECT JobsDeliveryVendor.DeliveryDocketID, JobsDeliveryVendor.DeliveryDocketNo, JobsDeliveryVendor.JobID, JobsDeliveryVendor.BatchNo, JobsDeliveryVendor.Quantity, JobsDeliveryVendor.QtyType, JobsDeliveryVendor.LabelCount, JobsDeliveryVendor.NumPallets, JobsDeliveryVendor.Status, JobsDeliveryVendor.[Material Description]
FROM JobsDeliveryVendor, tblNums
WHERE (((JobsDeliveryVendor.JobID)=[Forms]![Jobs]![JobID]) AND ((JobsDeliveryVendor.Status)>"0") AND ((tblNums.ID)<=[NumPallets]));
I am a newbie to the DoCmd.RunSQL but I would like to try and call the above using the
DoCmd.RunSQL. Could anyone point me in the direction on how to perform this?
Thanks for the help