In my reports menu I need to print a report of all items in a combo box - The combo box reads:

SELECT tblName.szName FROM tblName UNION SELECT "(All)" FROM tblName;

This brings up "All" at the top of the combo box but the report has no data. Is my query the problem or do I need more code to run this type of report?

have you tied using a * in place of all? and try to let access right the sql code for you and see what it does.

Can I ask a stupid(or genius) question?

If you want all entries why are you specifying criteria at all?