Access SQL - add constant row to result
Posted on 2013-06-19
I want to create a report producing job totals for each division, and then list new job details if any. I want a total for every division, plus a total for (NONE) as some jobs don't have a division.
SO, my report source query needs to have every division from DIVISION table, plus one more (NONE).
I have done this before but just can't find it.
It is something like:
select DivisionName from DIVISION UNION ALL select "(NONE)"
but access requires an input table for this last bit.
I do not want to create a dummy table, nor add (NONE) to my DIVISION table. I'm sure I have been successful with this before. I am dreaming?