You’re offline. This is a read only version of the page.
153
Hi Guys,
For example: I have 3 fields. i.e. no,description, quantity.
in my no field ,i have the duplicate values.& also description have same values.
I want ,that 2 same entry ,should i get in one entry.as shown in below image.i.e. result.
And that same entry have quantity also , so i want sum of that quantity as shown below image.
Is there is any way to do this.
In a report, this can be done in the layout, by adding a group. For example group on the Number, and then calculate a Sum of the Quantity.
In a query, you can add the three fields as columns, and then calculate a Sum method on the Quantity. This will then add a group on the No and Description.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (