Find Jobs
Hire Freelancers

microsoft access dsum running total issue

$10-30 CAD

Terminado
Publicado hace más de 5 años

$10-30 CAD

Pagado a la entrega
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!
ID del proyecto: 17360790

Información sobre el proyecto

10 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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
Avatar del usuario
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 en 3 días
4,9 (158 comentarios)
6,8
6,8
Avatar del usuario
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 en 1 día
4,7 (139 comentarios)
6,1
6,1
Avatar del usuario
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 en 1 día
4,5 (46 comentarios)
6,1
6,1
Avatar del usuario
Hi, I can instantly do it. Thanks. Stay tuned, I'm still working on this proposal.
$25 CAD en 1 día
5,0 (1 comentario)
0,4
0,4
Avatar del usuario
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 en 2 días
5,0 (1 comentario)
0,3
0,3
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CANADA
Meaford, Canada
5,0
3
Forma de pago verificada
Miembro desde oct 5, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.