Hello,
First, I thank you for any help you can provide, I truly appreciate it.
I have a Report based on a query in Access and I need it to sort in a different manner and can’t seem to make it do that as the item I want to sort is a formula …
Right now it sorts like this…first on month and year – oldest to newest – which is great.
Second sort is sorting on the reviewer’s name which I don’t want, I want it to sort on their monthly total – (number they reviewed within that month) with the one with the most reviews first – but that is a formula (see below).
What I have currently:
January 2013 Monthly Total: 7 % of Grand Total 100%
Reviewer 1 2 28.6%
Reviewer 2 4 57.1%
Reviewer 3 1 14.3%
This is what I would like:
January 2013 Monthly Total: 7 % of Grand Total 100%
Reviewer 2 4 57.1%
Reviewer 1 2 28.6%
Reviewer 3 1 14.3%
The formula is in the Reviewer Name Header and looks like this:
Reviewer Full Name =Count([Review Date]) =Count([Review Date])/[AccessTotalsReview Date1]
Again, thank you for any help.
Lilly
First, I thank you for any help you can provide, I truly appreciate it.
I have a Report based on a query in Access and I need it to sort in a different manner and can’t seem to make it do that as the item I want to sort is a formula …
Right now it sorts like this…first on month and year – oldest to newest – which is great.
Second sort is sorting on the reviewer’s name which I don’t want, I want it to sort on their monthly total – (number they reviewed within that month) with the one with the most reviews first – but that is a formula (see below).
What I have currently:
January 2013 Monthly Total: 7 % of Grand Total 100%
Reviewer 1 2 28.6%
Reviewer 2 4 57.1%
Reviewer 3 1 14.3%
This is what I would like:
January 2013 Monthly Total: 7 % of Grand Total 100%
Reviewer 2 4 57.1%
Reviewer 1 2 28.6%
Reviewer 3 1 14.3%
The formula is in the Reviewer Name Header and looks like this:
Reviewer Full Name =Count([Review Date]) =Count([Review Date])/[AccessTotalsReview Date1]
Again, thank you for any help.
Lilly