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?
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?