You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
NotThamesWater
@Chalfie
Hi!!!!!!!
Me again!!!
lolz
Seriously.
I'm looking at the data extraction routine (from Access). It appears to be "run query 1" then "run query2" then "run query 3" then "run query 4".
How do I link them together?
For example 1+2, which simplistically deletes all data from 2013 in one table and then adds in the data from 2013 from another table.
How do I combine (or where can I find some info about how to do it pls):
Delete [table1].[Field1]
From [table1]
WHERE ((([table1].[Field1])>#date#));
with
INSERT INTO [field1], then lots more [fields]
FROM [table2]