I get a download from verizon with cell phone information. the data includes the cost center which is the account the phone is paid from. and other information like monthly access charges and usage charges taxes etc.
the spreadsheet has the cost centers grouped together with a subtotal for each cost center. Right now i copy data from the spreadsheet into the tables into the database. But I was trying to find a way of parsing out and getting the data to be aligned the tables are.
what i am trying to do is to create a query to get all of the subtotals with the cost centers. I am not sure how to get the associated cost centers to replace the word subtotal
I would like to get it to look like
CC12345 PG11233 66.54 0.00 1.03
CC23456 PG23456 200.00 17.00 15.00
I need to copy all of the subtotal information into a summary table but the data looks like below
Cost Center charges usage charges taxes
CC12345 PG11233 66.54 0.00 1.03
Subtotal 66.54 0.00 1.03
CC23456 PG23456 100.00 6.00 3.00
CC23456 PG23456 10.00 2.00 3.00
CC23456 PG23456 20.00 1.00 3.00
CC23456 PG23456 30.00 3.00 3.00
CC23456 PG23456 40.00 5.00 3.00
Subtotal 200.00 17.00 15.00
Is there a way of doing this in Access?
Thank You
Jim Wagner
_._,_._,_
Groups.io Links:
You receive all messages sent to this group.
View/Reply Online (#116291) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]
_._,_._,_
Tidak ada komentar:
Posting Komentar