Count is throwing off sort

StephenB

Registered User.
Local time
Today, 16:32
Joined
Apr 18, 2002
Messages
101
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.
 
Where have you applied the sort order? In the underlying query or the report itself? Try the underlying query if not already done.
 
You have to set the sort/group options on the Report, not the underlying query
 
Thanks. I had the sort on the query. I placed the sort on the report and now it's fine. Any comment on why the report would just suddenly decide to rearrainge the order?
 

Users who are viewing this thread

Back
Top Bottom