UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Sorting In Report, Access 2013    
 
   
msnarayanan
post Dec 22 2017, 08:00 AM
Post#1



Posts: 277
Joined: 28-May 13



dear all
I have a form to add data (currency field). for amounts
received from many people.

I have created a report to show sender's name and amount.

when the report is run, all the sender's name and amounts
are shown, probably based on dates or names in the alphabetical
order.

is it possible to show the amounts in descending order
(highest to lowest).
I think this can be done by selecting "order by". but I
do not know how to proceed with that.

shall be thankful for your help.

m s narayanan
Go to the top of the page
 
Jeff B.
post Dec 22 2017, 08:02 AM
Post#2


UtterAccess VIP
Posts: 10,140
Joined: 30-April 10
From: Pacific NorthWet


As you are probably already aware of, Access stores data in tables, regardless of whether you use forms to enter the data. Reports are generally used to display data in a printed format, and can be based on either tables or on queries. If you use a query to 'feed' your report, you can use the "Order By" feature in the query itself.
Go to the top of the page
 
GroverParkGeorge
post Dec 22 2017, 08:17 AM
Post#3


UA Admin
Posts: 33,777
Joined: 20-June 02
From: Newcastle, WA


There are a couple of ways to apply Sort Order in a report. One is the method Jeff suggests. Another is to use the Sort Order property of the report itself.
Attached File  sortreport.jpg ( 110.8K )Number of downloads: 4
Go to the top of the page
 
msnarayanan
post Dec 22 2017, 10:24 AM
Post#4



Posts: 277
Joined: 28-May 13



dear sirs

very many thanks for your suggestions/help.

can sorting be done on group totals.
if some persons make multiple remittances
sorting is to be made in the report or query
based on the total of the amounts and not on
individual remittances.

thanks

m s narayanan
Go to the top of the page
 
GroverParkGeorge
post Dec 22 2017, 10:35 AM
Post#5


UA Admin
Posts: 33,777
Joined: 20-June 02
From: Newcastle, WA


You should be able to select the appropriate combination and sequence of sorting to get the result you want. Try it out and see what results you can achieve.

You can create a group footer with the totals, and sort on that.
This post has been edited by GroverParkGeorge: Dec 22 2017, 12:24 PM
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    19th October 2018 - 02:40 PM