1 of 1 people found this helpful
Does this work?
SELECT "TABLE1" as [Table], [PERIOD_DATE]
SELECT "TABLE2" as [Table], [PERIOD_DATE]
What seems to work is:
SELECT 'TABLE1' AS "TABLE", [PERIOD_DATE]
That could be the correct syntax, I've spent far too long working with Access