A
alex
Hello,
using Access '03...
I have a simple form based on table.
I have an unbound textbox and am trying to sum 3 other bound textboxes
per record.
The table looks like this:
TimeID CaseHours XYZHours OtherHours
20081215 5 1 3
20081216 1 12 8
I'd like to sum the hours fields per TimeID...e.g, 9 for the first
record. When I scroll to the second record the unbound textbox
(TotalHrs) should read 21.
I've researched DSum, but it doesn't appear to work. I also messed
around with the form header and footer to no avail.
Any ideas?
This seems like it should be pretty simple.
alex
using Access '03...
I have a simple form based on table.
I have an unbound textbox and am trying to sum 3 other bound textboxes
per record.
The table looks like this:
TimeID CaseHours XYZHours OtherHours
20081215 5 1 3
20081216 1 12 8
I'd like to sum the hours fields per TimeID...e.g, 9 for the first
record. When I scroll to the second record the unbound textbox
(TotalHrs) should read 21.
I've researched DSum, but it doesn't appear to work. I also messed
around with the form header and footer to no avail.
Any ideas?
This seems like it should be pretty simple.
alex