LaBelette
It means "The Weasel"
- Local time
- Today, 00:20
- Joined
- Mar 12, 2004
- Messages
- 68
Hi,
I need to Sum the values in a detail section of a Form.
My form should look like this :
The Total column should contains all the hours entered, but not only for this week.
The records in the detail section comes from a Temporary table based on my table TDisponibilite. The query RSurtemps is based on that same table.
I've tryed using a DSum in the RecordSource of my Total field, but if shows the same number for each row. If I use a Sum in my query, I can manage to get the results, but then my other fields can't be updated.
=DSum(""[disHSurtemps]"", ""RSurtemps"", ""[quaDate] < #" & Format(datPeriode + 13, "mm-dd-yyyy") & "#"")
Is there a way to fix that?
I need to Sum the values in a detail section of a Form.
My form should look like this :
Code:
Name Monday Thursday ... Sunday Total
---------------------------------------------------
Jack Tremblay 10 2 ... -4 125
Pierre Wilson 0 -5 ... 5 80The Total column should contains all the hours entered, but not only for this week.
The records in the detail section comes from a Temporary table based on my table TDisponibilite. The query RSurtemps is based on that same table.
I've tryed using a DSum in the RecordSource of my Total field, but if shows the same number for each row. If I use a Sum in my query, I can manage to get the results, but then my other fields can't be updated.
=DSum(""[disHSurtemps]"", ""RSurtemps"", ""[quaDate] < #" & Format(datPeriode + 13, "mm-dd-yyyy") & "#"")
Is there a way to fix that?
