hi,
I have an append query which I am trying to append to multiple tables at once is this possible.
I have the following sql which isnt working at the minute.
ThanksCode:INSERT INTO [MOT:Bathroom] ( propref ) INSERT INTO [MOT:Bedroom1] ( propref ) INSERT INTO [MOT:Bedroom2] ( propref ) SELECT Propertyextract.propref FROM Propertyextract;