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

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

Post by RmFyZWV » Tue, 06 Jun 2006 02:28:01


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
 
 
 

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

Post by Duane Hook » Tue, 06 Jun 2006 03:05:16

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.
--
Duane Hookom
MS Access MVP

 
 
 

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

Post by RmFyZWV » Tue, 06 Jun 2006 03:12:02

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
 
 
 

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

Post by Duane Hook » Tue, 06 Jun 2006 03:22:37

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.
--
Duane Hookom
MS Access MVP