Adding an "Over All Sum" textbox

[Bryan]

I did a query to display farm fields yield results in descending order to
show the highest yielding to the lowest yielding, along with the acres within
the field. I added a textbox to show the sum of all of the acres, as well as
an average for all of the fields combined. When I look at my report after I
made the changes, it no longer has the avg. yield in descending order.

It looks like it put another field (my clients ID) in descending order
instead. Any ideas?

Thanks!

 

[John Vinson]

I did a query to display farm fields yield results in descending order to
show the highest yielding to the lowest yielding, along with the acres within
the field. I added a textbox to show the sum of all of the acres, as well as
an average for all of the fields combined. When I look at my report after I
made the changes, it no longer has the avg. yield in descending order.

It looks like it put another field (my clients ID) in descending order
instead. Any ideas?

Thanks!

The Report ignores the sort order on the query. Instead, use the
Report's Sorting and Grouping property (right mouseclick the little
box at the upper left intersection of the rulers) to set it.

John W. Vinson[MVP]