G
Guest
I have 12 tabs in Excel that are Linked in Access. I want to create a Union
query with a running sum to preserve the sort order.
SELECT *
FROM Period 1
WHERE Vin1>"1"
UNION SELECT *
FROM Period 2
WHERE Vin1>"1"
Should return...
Running
Sum Vin Table
1. B2345 Period 1
2. J7890 Period 2 etc..
Thanks in advance.
query with a running sum to preserve the sort order.
SELECT *
FROM Period 1
WHERE Vin1>"1"
UNION SELECT *
FROM Period 2
WHERE Vin1>"1"
Should return...
Running
Sum Vin Table
1. B2345 Period 1
2. J7890 Period 2 etc..
Thanks in advance.