Print Report of ALL items in a combo box

[Mansfield]

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?

 

[Camon]

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.

 

[Fornatian]

Can I ask a stupid(or genius) question?

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