HOWTO change the order of display

  • Thread starter Thread starter Troy
  • Start date Start date
T

Troy

Hi,

In the Client Header's I have the Client_Name, =Count([Product]) and
=Sum([Cost_Product]).

In the (hidden) Detail Section, I've Qty_Product and Cost_Product.



The Report lists the 'Client's Name', 'Total Products Purchased' and '$$
invested to date' ordered by Client_Name.



I would like to change the order showing 'Total Products Purchased' as focus
field. In other words, I would like to see the client with the most orders
to the less.

Because the =Count([Product]) is a calculated field, I don't know HOWTO
change its order.

Can someone help please? TIA

Eleonora
 
Troy said:
In the Client Header's I have the Client_Name, =Count([Product]) and
=Sum([Cost_Product]).

In the (hidden) Detail Section, I've Qty_Product and Cost_Product.

The Report lists the 'Client's Name', 'Total Products Purchased' and '$$
invested to date' ordered by Client_Name.

I would like to change the order showing 'Total Products Purchased' as focus
field. In other words, I would like to see the client with the most orders
to the less.

Because the =Count([Product]) is a calculated field, I don't know HOWTO
change its order.
Click to expand...


The Count will have to be in the report's record source
query to do what you want.

This might be easier to do if you could use a Totals type
query and eliminate the data that you have in the detail
section. After all, if the detail section is hidden, why
bother including all that data.

I think the report could be simplified if you use a query
like:

SELECT Client_Name,
Count([Product]) As ProdCnt,
Sum([Cost_Product]) As ProdSum
FROM thetable
GROUP BY Client_Name

This way the report does not need any grouping, and can be
sorted by the calculated ProdCnt field
 
Back
Top