control to hold a single value in a report. (access 2002)
please see attached..
what will be the right control to place where the marked green box is.
the query in the 'REPORT' whose property is highlighted is as below (simplified, leaving out the complex conditions)
SELECT field1, Field2, Field3,Field4
WHERE Condition1 AND condition2
ORDER BY Field2 DESC;
The new field to introduce below the above 'REPORT' control, would be of the below format:
WHERE Condition1 AND condition2 heaader.png