Forum Discussion
SUM of numbers in a sequence
Hello. I have a billing report in Excel that I use to enter claims in a state system. The system requires me to enter a record for each date, along with the number of hours and the total amount. Ho...
Take a look on a sample file.
All you need to do is input your "Date From" and "Date To"
and it will automatically calculate the hours and amounts within that date.
- Hi! My Access dBase actually creates the records. I don’t input them. I copy and paste them to Excel. I just thought I could create a formula in Excel that would calculate the amounts that were sequential in date. No worries. Maybe I need to look at the whole process from another angle. Happy New Year!
Hi gdougher (Happy New Year too)
My Access dBase ... Maybe I need to look at the whole process from another angle
#1 Instead of copy/paste from Access to Excel, why not using https://support.microsoft.com/en-us/office/about-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a (from Excel) to get the data from Access
#2 Once the records are gathered, aggregate as desired with Power Query and return the output to an Excel sheet:
The attached sample doesn't get the data from Access but it's fairly easy to setup
Any question feel free to ask
