ZKHADI Member Local time Today, 07:00 Joined Apr 5, 2021 Messages 118 Jan 26, 2022 #1 i have a query uploaded pic here. a customer have multiple items. and as you can see i need to show as one customer and his items sales to sum total. anyone ? Attachments Untitled.png 110.9 KB · Views: 263
i have a query uploaded pic here. a customer have multiple items. and as you can see i need to show as one customer and his items sales to sum total. anyone ?
June7 AWF VIP Local time Yesterday, 17:00 Joined Mar 9, 2014 Messages 6,126 Jan 26, 2022 #2 Sounds like an aggregate query. Use Sum function. Or build a report and use its Sorting & Grouping features with aggregate calcs. This allows showing detail records as well as summary calcs.
Sounds like an aggregate query. Use Sum function. Or build a report and use its Sorting & Grouping features with aggregate calcs. This allows showing detail records as well as summary calcs.
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 10:00 Joined May 7, 2009 Messages 20,727 Jan 26, 2022 #3 on ExtPrice use Sum instead of Group in total row.
ZKHADI Member Local time Today, 07:00 Joined Apr 5, 2021 Messages 118 Jan 27, 2022 #4 arnelgp said: on ExtPrice use Sum instead of Group in total row. Click to expand... Love you bro it worked
arnelgp said: on ExtPrice use Sum instead of Group in total row. Click to expand... Love you bro it worked
