Jerry Stoner
11-15-2001, 08:13 AM
Can anyone tell me what is wrong with this; I get a "Syntax" error that points to the Where statement? All spelling is correct, also I have another query whose SQL LOOKS identical (different field name)that works.
Any help greatly appreciated.
INSERT INTO tblActiveEquipment ( "Sales Order" )
SELECT DMax("Sales Order","tblActiveEquipment")+1 AS Expr1
FROM tblActiveEquipment
WHERE (((tblActiveEquipment.Sales Order)=DMax("Sales Order","tblActiveEquipment")));
Any help greatly appreciated.
INSERT INTO tblActiveEquipment ( "Sales Order" )
SELECT DMax("Sales Order","tblActiveEquipment")+1 AS Expr1
FROM tblActiveEquipment
WHERE (((tblActiveEquipment.Sales Order)=DMax("Sales Order","tblActiveEquipment")));