M
M Skabialka
I have a form in Access 2007 which tracks employee hours on tasks. The form
shows 7 controls, SunHours, MonHours, TueHours, etc. In the footer I have
another 7 which add hours for each day as a total. e.g SumSunHours =
Sum([SunHours]). If I leave it at that it works. I then added an 8th
control WeekTotal with the source being: =Sum([SunHours] + [MonHours] +
[TueHours] + [WedHours] + [ThuHours] + [FriHours] + [SatHours])
However it reports the same week total result for every record
S M T W T F S WeekTotal
0 2 3 1 2 3 0 11
0 0 1 0 0 0 0 11
--------------------------
0 2 4 1 2 3 0 #error
I also added a grand total where I show #error above. I tried adding all
the sub-totals to the left,
=Sum([SumSunHours] + [SumMonHours] + [SumTueHours] + [SumWedHours] +
[SumThuHours] + [SumFriHours] + [SumSatHours])
and I tried =Sum([WeekTotal]). In both cases not only do I get the #error,
I also get the same #error for all day sub-totals and the week sub-totals.
If I remove the grand total control the other sub-totals show numbers, but
the addition is still wrong for the WeekTotal on subsequnet lines.
I've done a compact/repair, copied the form, removed the totals and
recreated them, etc.
Why would my subtotals for each week all show the same for different
records, and why won't the grand total work?
Mich
shows 7 controls, SunHours, MonHours, TueHours, etc. In the footer I have
another 7 which add hours for each day as a total. e.g SumSunHours =
Sum([SunHours]). If I leave it at that it works. I then added an 8th
control WeekTotal with the source being: =Sum([SunHours] + [MonHours] +
[TueHours] + [WedHours] + [ThuHours] + [FriHours] + [SatHours])
However it reports the same week total result for every record
S M T W T F S WeekTotal
0 2 3 1 2 3 0 11
0 0 1 0 0 0 0 11
--------------------------
0 2 4 1 2 3 0 #error
I also added a grand total where I show #error above. I tried adding all
the sub-totals to the left,
=Sum([SumSunHours] + [SumMonHours] + [SumTueHours] + [SumWedHours] +
[SumThuHours] + [SumFriHours] + [SumSatHours])
and I tried =Sum([WeekTotal]). In both cases not only do I get the #error,
I also get the same #error for all day sub-totals and the week sub-totals.
If I remove the grand total control the other sub-totals show numbers, but
the addition is still wrong for the WeekTotal on subsequnet lines.
I've done a compact/repair, copied the form, removed the totals and
recreated them, etc.
Why would my subtotals for each week all show the same for different
records, and why won't the grand total work?
Mich