I'm tracking issues on a db in Access 98. I have a report that displays open issues. I set the query the report is based on to sort by issue number in ascending order.
I wanted to display the number of open issues so I created a field with the following as the control source: =Count([Issue_Number]).
At first I placed this field in the page footer, but I got "#Error". Then I tried it on the report footer, but now the order of issues is out of wack. The report starts off with issue number 25 instead of 1.
Any help is appreciated.
I wanted to display the number of open issues so I created a field with the following as the control source: =Count([Issue_Number]).
At first I placed this field in the page footer, but I got "#Error". Then I tried it on the report footer, but now the order of issues is out of wack. The report starts off with issue number 25 instead of 1.
Any help is appreciated.