Question about Union queries

[Guest]

I would like to make a list or combo box based off a table, with the addition
of a single line that doen't exist in any table.

What I'm trying:

SELECT [DeptNo], [DeptName] FROM tDepartments
UNION SELECT "*" AS [DeptNo], "All Deptarments" as [DeptName];

Obviously, this isn't working because there is no FROM clause in the union.
Is there a way to accomplish this?

Thanks in advance,
John

 

[Guest]

Sorry for the mispost. Moved to the more appropriate group of Access Queries