Hi, I have a little issue with a running sum in a query.
The following fields are involved: WorkDate (date field), HoursPaid (number field), TISort (a time field), StaffFK (an AutoID number field). Data source is the query: qryPayPeriodSummary
I want a running total to have a running total of WorkHours for each StaffFK. It has to be sorted by ascending WorkDate and then ascending TISort. There are duplicats in WorkDate and duplicates in TISort for each StaffFK, but no duplicate WorkDate and TISort combinations for a particular StaffFK. Here is my DSum formula, it does the running sum but not in the correct order.
This is what I have so far:
RunningTotal: DSum("[HoursPaid]","[qryPayPeriodSummary]","[StaffFK]=" & [StaffFK] & " AND [WorkDate] <= #" & [WorkDate] & "# And [TISort] <= #" & [TISort] & "# ")
Help please!
I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality!
Relevant Skills and Experience
Microsoft Access, SQL, visual basic
Proposed Milestones
$30 CAD - Project completed
$30 CAD en 0 día
4,9 (114 comentarios)
6,2
6,2
10 freelancers están ofertando un promedio de $28 CAD por este trabajo
The formula looks good
You might need to make sure that the query where you are putting the running sum is sorted by StaffID field followed by Time field.
Also make sure that the time field is in correct format.
If all is correct please send me the database for review
Rajiv
Hi..
I have gone through your project details and would like to have an opportunity to work on it. Being experienced in working on MS Access extensively and familiar with related functions and queries, I assure you of quick solution.
Waiting for your response for further discussion. Thanks.
Hello,
I have gone through your requirement.
I have more than 5+ yrs of experience in MS Access & SQL Server.
Pls message me to discuss it further.
Also, if possible, pls provide file, so that I can provide the solution.
Thanks,
Saurabh
In the last step of this form additional information of 1000 characters can be added!
Relevant Skills and Experience
I am an expert developer on Ms Access Platform. So far I didn't face any issue that failed to fix. I have developed around 40 Applications using MS access 2003/2016.
Proposed Milestones
$15 CAD - Observing and analysis the problem
$20 CAD - Deliver the solution
Additional Services Offered
$10 CAD - I can suggest to improve your current system to get the most from it.
I want to know that the running sum you are asking is for a report or query or form?
Whatever your requirement I will be able to find your solution. I love to fix problem!