This content has been marked as final.
Show 3 replies
-
1. Re: Manual Field in Custom SQL
Dave Rawlings Jul 7, 2016 7:43 AM (in response to Todd Moses)1 of 1 people found this helpfulDoes this work?
SELECT "TABLE1" as [Table], [PERIOD_DATE]
FROM MYTABLE
UNION ALL
SELECT "TABLE2" as [Table], [PERIOD_DATE]
FROM MYTABLE
-
2. Re: Manual Field in Custom SQL
Todd Moses Jul 7, 2016 8:01 AM (in response to Dave Rawlings)What seems to work is:
SELECT 'TABLE1' AS "TABLE", [PERIOD_DATE]
FROM MYTABLE
-
3. Re: Manual Field in Custom SQL
Dave Rawlings Jul 7, 2016 8:07 AM (in response to Todd Moses)That could be the correct syntax, I've spent far too long working with Access