Access Denied
Access is stupid.
I can run a query in MySQL that allows me to “group” results by any field that I want. Access only allows me to do that based upon integer fields. Stupid. The other thing that is stupid is if I run a query in Access and tell it to sort, I will get an ordered result, but only in the “dataset” view. Take the sorted data and create a report from it and it will be in whatever order the program decides is best. In order to create a sorted report the data has to be resorted in the reports section of the program. And the aforementioned grouping does work in the sorting and grouping functions in the reports.
The next thing that doesn’t work is page numbering by group. I’m trying to make my life and the life of #3 easier (against my better judgment) by creating a report that will do group by a field name, give totals for a dollar field by the group and restart numbering for the next group. Well, this isn’t built in and one has to learn to code just to put a page number on the page. I’m not saying that you can’t put a page number on the report, just that you can’t put a group page number on the page. Page numbers are fine, but when I’m printing 30 plus pages, but only between one and three for each group, why can’t I get a group page number? Because apparently nobody would ever want to do that. Now there is a supposed way to do it according to: this document. I guess I have to pound on it again later today - while it’s quiet.
