Find Jobs
Hire Freelancers

microsoft access dsum running total issue

$10-30 CAD

Completato
Pubblicato più di 5 anni fa

$10-30 CAD

Pagato al completamento
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!
Rif. progetto: 17360790

Info sul progetto

10 proposte
Progetto a distanza
Attivo 6 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
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 giorno
4,9 (114 valutazioni)
6,2
6,2
10 freelance hanno fatto un'offerta media di $28 CAD
Avatar dell'utente
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 giorni
4,9 (158 valutazioni)
6,8
6,8
Avatar dell'utente
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 giorno
4,7 (139 valutazioni)
6,1
6,1
Avatar dell'utente
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 giorno
4,5 (46 valutazioni)
6,1
6,1
Avatar dell'utente
Hi, I can instantly do it. Thanks. Stay tuned, I'm still working on this proposal.
$25 CAD in 1 giorno
5,0 (1 valutazione)
0,4
0,4
Avatar dell'utente
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 giorni
5,0 (1 valutazione)
0,3
0,3
Avatar dell'utente
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 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: CANADA
Meaford, Canada
5,0
3
Metodo di pagamento verificato
Membro dal ott 5, 2017

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.