report reverse

[yessir]

In the attached database there is a report: "rptIndividualPointsTotal" which is based off of the query: "qryPointsTotal".

the report has each person listed under the a point total. currently it lists the point total from least to greatest.

Is there a way to have that report list the points from greatest to least?

Thanks
~

 

[Rich]

Change the Sorting/Grouping option to Ascending

 

[yessir]

Change the Sorting/Grouping option to Ascending

The problem is that I have put the Points at the top when creating levels sp that the points total only appears once per group of prople with that many points.

 

[Hayley Baxter]

The problem is that I have put the Points at the top when creating levels sp that the points total only appears once per group of prople with that many points.

if you change the points to descending it will list the greatest value first grouped by number of points, then in ascending order by name then after, isn't that what you were after?

 

[yessir]

that is what I am after,

but since I put the points in as their own group they do not give the option to order (that I can find)

just look at it, and try what i described above

~Thanks

 

[Hayley Baxter]

Just go into sorting and grouping and where you have points listed first change this from ascending to descending.

 

[yessir]

lol,


oops, sorry, one of those days I guess...


Ironically I cracked a problem today that has been plaguing me for 2 weeks!
Yet I couldn't remember this...


maybe there's hope for me yet!
~THanks

 

[Hayley Baxter]

lol,


oops, sorry, one of those days I guess...


Ironically I cracked a problem today that has been plaguing me for 2 weeks!
Yet I couldn't remember this...


maybe there's hope for me yet!
~THanks

At least you can see the funny side of it, I'm not laughing HONEST

I get days like that too, quite often in fact

 

[yessir]

I am tryig to get the count to work in that form for the total in each point range.

as well as for the total in each color kids form

i put in atext box with =Count(*) but I get #Error

little help..

 

[Hayley Baxter]

Are you trying to count the amount of people who have those points?

Where are you puting the =count(*) and are we still talking about the report? If so you will need to include it in the Group Footer not the Report Footer, you don't have a group footer at the moment so add it in.

Hay

 

[yessir]

I got it now, thanks!