desperate...

[yessir]

Hello all,

I guess I am back for another short stint!

I have this db with a report (slimmed down of course).

I wish the report to display as is right now, but order the entrys by the highest point total to the lowest. (ie: the field sum = sum([Points]))

This is very much desired and needed today!

You may notice that I do have 2 querys which do the effect i wish in 2 levels,
1) to gather all the info desired
2) to sum total and order thereby

Right now the report does not use these querys rather it uses SQL to deliver what it displayed...

Please, could someone help!

Thanks...
~

 

[yessir]

'97 for mile-o-phile if so inclined!

~

 

[Mile-O]

Like this?

 

[yessir]

that actually didn't work...

if you go into the report and go through a bit you'll see there are problems...

I know for fact the highest total is 47...

Please help again...
~

 

[RayH]

Not exactly elegant but does this work for you?

 

[yessir]

Thank you so much, that has bothered me for a while now!

You're great
..now if only i could get my javascript print function to work...

~