<div>
<div class="content wysiwyg-content">
I want to create a report producing job totals for each division, and then list new job details if any. &nbsp;I want a total for every division, plus a total for (NONE) as some jobs don't have a division.<br />
<br />
SO, my report source query needs to have every division from DIVISION table, plus one more (NONE).<br />
<br />
eg.<br />
red group<br />
blue group<br />
green group<br />
(NONE)<br />
<br />
<br />
I have done this before but just can't find it.<br />
<br />
It is something like:<br />
select DivisionName from DIVISION UNION ALL select &quot;(NONE)&quot;<br />
<br />
but access requires an input table for this last bit.<br />
<br />
I do not want to create a dummy table, nor add (NONE) to my DIVISION table. &nbsp;I'm sure I have been successful with this before. &nbsp;I am dreaming?
</div>
</div>


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).

eg.
red group
blue group
green group
(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?

Access SQL - add constant row to result

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.