Good morning,
I have a table that has data like this,
A 11
A 34
B 21
B 55
B 65
C 32
C 12
C 43
C 10
and would like to subtract rows only when the letters are equal. For example, for the letter B, the query result would look like:
B 21 0
B 55 34
B 65 10
is this possible in Access? I can achieve this in Excel in 5 seconds but my boss wants it in Access.
THanks!!!!
See if this link helps
https://support.microsoft.com/en-us/...crosoft-access
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thank you. I will check it out.
Originally Posted by alansidman
yes this link is also useful for me thanks
Last edited by AliGW; 12-16-2019 at 11:35 AM.
Sohailafzal - you can use the reputation system to thank members for posts you've found useful.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks