compress total

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

compress total

Post by sal21 »

In listview have: (the other column is not important)

column 3 QTA
column 4 PREZZO
column 11 ID

Now based the same value in column 11, i need top compress the item with a new sum into an array SCHIACCIA_SOMMA...

to the and for example ID=2:

new_value for QTA based ID 2 newQTA=6
new_value for TOTALE based ID 2 newTOTALE =78,00
ecc...
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78232
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: compress total

Post by HansV »

I'd use a Totals query based on the source data of the listview control.
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

Re: compress total

Post by sal21 »

HansV wrote:
10 Apr 2022, 16:04
I'd use a Totals query based on the source data of the listview control.
hummm...
i cannot use a query totals.
i pass data in listview from other controll, similar tetxbox, label, eccc...

User avatar
HansV
Administrator
Posts: 78232
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: compress total

Post by HansV »

Please explain in more detail what you want to do.
Best wishes,
Hans