microsoft access dsum running total issue

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!

Evner: Databehandling, Programmering af database, Microsoft Access

Se mere: i need a brilliant microsoft access programmer in singapore, where can i get microsoft access activex controls, i need to write some simple databases in microsoft access or file maker pro, running total in access form, ms access running sum continuous form, access report running sum, dsum access, running total in access query, access running total by date, ms access running count within group, access dsum running total by date, data processing, database programming, microsoft access, issue tracking microsoft access, issue tracking system microsoft access, microsoft access issue tracking, microsoft access issue tracking system, issue tracking microsoft access template 2003, microsoft access issue tracking database

Om arbejdsgiveren:
( 2 bedømmelser ) Meaford, Canada

Projekt ID: #17360790

Tildelt til:


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 Flere

$30 CAD in 0 dage
(91 bedømmelser)

11 freelancere byder i gennemsnit $28 på dette job


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 Flere

$35 CAD in 3 dage
(157 bedømmelser)

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 Flere

$25 CAD på 1 dag
(116 bedømmelser)

Hi, here before better to make query for simplify running total Relevant Skills and Experience vba,ado,dao,sql Proposed Milestones $50 CAD - default

$30 CAD på 1 dag
(46 bedømmelser)

I can fix this issue. Let me review the database. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. Let me know the full sp Flere

$30 CAD på 1 dag
(69 bedømmelser)

I have 30 years’ of experience in Microsoft (all suites) i.e. Word, Excel, Access, Publisher and Power Point. Relevant Skills and Experience Data Processing, Database Programming, Microsoft Access. Proposed Milestone Flere

$25 CAD på 1 dag
(1 bedømmelse)
$25 CAD in 3 dage
(2 bedømmelser)

Hi, I can instantly do it. Thanks. Stay tuned, I'm still working on this proposal.

$25 CAD på 1 dag
(1 bedømmelse)

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 Flere

$35 CAD in 2 dage
(0 bedømmelser)

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 so Flere

$15 CAD in 2 dage
(0 bedømmelser)
$30 CAD in 2 dage
(0 bedømmelser)