penandpaper
Registered User.
- Local time
- Today, 15:22
- Joined
- Aug 7, 2017
- Messages
- 20
Hello,
I'm new to ms access and I was wondering how do you insert a new row that has the the sum of a query?
The table look's like this:
Object Account | Subledger | JE Explanation | Actual Ammount | Remarks
Tom*************abc*******Orange********100.00*******Apple
Tom*************abc*******Orange********300.00*******Apple
Dianne***********xyz*******Banana********250.00****** Apple
Jerry*************jkl*******Grapes********100.00******* Apple
Tom*************abc*******Orange********100.00*******Apple
and the output I want is:
Object Account | Subledger | JE Explanation | Actual Ammount | Remarks
Tom*************abc*******Orange********100.00*******Apple
Tom*************abc*******Orange********300.00*******Apple
Tom*************abc*******Orange********100.00*******Apple
Tom**********abc********Apple********100.00*******Apple
Basically I need to add a new row base on a query of duplicates in object account, subledger and JE explanation.
The new amount of the new row is the sum of the duplicates and the remarks of the duplicates is the JE explanation of the new row.
I don't know if this is possible or not, and I'am running out of ideas for this one.
Any help on this?
PS: Pardon for the sample table I can't post pictures yet
I'm new to ms access and I was wondering how do you insert a new row that has the the sum of a query?
The table look's like this:
Object Account | Subledger | JE Explanation | Actual Ammount | Remarks
Tom*************abc*******Orange********100.00*******Apple
Tom*************abc*******Orange********300.00*******Apple
Dianne***********xyz*******Banana********250.00****** Apple
Jerry*************jkl*******Grapes********100.00******* Apple
Tom*************abc*******Orange********100.00*******Apple
and the output I want is:
Object Account | Subledger | JE Explanation | Actual Ammount | Remarks
Tom*************abc*******Orange********100.00*******Apple
Tom*************abc*******Orange********300.00*******Apple
Tom*************abc*******Orange********100.00*******Apple
Tom**********abc********Apple********100.00*******Apple
Basically I need to add a new row base on a query of duplicates in object account, subledger and JE explanation.
The new amount of the new row is the sum of the duplicates and the remarks of the duplicates is the JE explanation of the new row.
I don't know if this is possible or not, and I'am running out of ideas for this one.
Any help on this?
PS: Pardon for the sample table I can't post pictures yet