Find Jobs
Hire Freelancers

microsoft access dsum running total issue

$10-30 CAD

Completed
Posted over 5 years ago

$10-30 CAD

Paid on delivery
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!
Project ID: 17360790

About the project

10 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 0 day
4.9 (114 reviews)
6.2
6.2
10 freelancers are bidding on average $28 CAD for this job
User Avatar
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
$35 CAD in 3 days
4.9 (158 reviews)
6.8
6.8
User Avatar
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.
$25 CAD in 1 day
4.7 (139 reviews)
6.1
6.1
User Avatar
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 in 1 day
4.5 (46 reviews)
6.1
6.1
User Avatar
Hi, I can instantly do it. Thanks. Stay tuned, I'm still working on this proposal.
$25 CAD in 1 day
5.0 (1 review)
0.4
0.4
User Avatar
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
$15 CAD in 2 days
5.0 (1 review)
0.3
0.3
User Avatar
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!
$35 CAD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Meaford, Canada
5.0
3
Payment method verified
Member since Oct 5, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.