How to prepare a report of sales in sum of multiple sales desc or.

[Guest]

Could somebody suggest me the way to prepare a roport of sales in descending
order of sum of Amount accumulated in either one or multiple transactions

 

[Duane Hookom]

You haven't given us much to work with. You can only sort a report on a
value derived from a single record in your report's record source. If "sum
of Amount accumulated" is in your report's record source, you can use the
sorting and grouping dialog in report design.

 

[Guest]

Just a further explanation to my question:
Customer Order # Date Amount

ABC
123 Ab St. New York, NY
26859 01/01/2006 305.00
Total Sale 305.00
DEF
456 Ab St. New York, NY.
26856 01/01/2006 300.00
26860 01/02/2006 100.00
Total Sale 400.00

In the above example $305 is brought earlier because it is more than the
individual 2nd transaction, where as the cumulative value of 2nd customer is
morethan the first customer. I want to bring the 2nd customer on the top of
the list.
Any tips are appreciated

 

[Guest]

Do I have to create a new field in the table? Can't I just create a logical
expression field in my query?

 

[Duane Hookom]

You can create a totals/group by query similar to your report's record
source query. Group by Customer and total the Amount. Add this query to your
report's record source query and join the Customer fields. You will then
have the SumOfAmount in your report's record source that you can use to sort
descending.

 

[Guest]

Can u pls. explain me further how can I create the total/Group in the query?

 

[Duane Hookom]

While in your query design, select View->Totals.