Colin Mckinney
|
Posted: 02/26/2004, 6:15 PM |
|
If I have a row in a grid that includes "number of hours worked" how can I have the totals dispayed on another form?
ie:
Record Form with Name, Date, Total hours
Editable grid with Job1, Loacation1, hours as a row. When the row is submitted hours field added to Total hours
any help?
|
|
|
DonB
|
Posted: 02/27/2004, 6:27 AM |
|
Set up the Record form to include SUM(hours) in a query against the "hours
table".
If it is necessary to see the total while the grid is being filled in, you
could do some javascript in the browser to sum the all the hours fields and
update the total each time the row hours changed.
--
DonB
http://www.gotodon.com/ccbth
<ColinMckinney@forum.codecharge (Colin Mckinney)> wrote in message
news:6403ea84b019d0@news.codecharge.com...
> If I have a row in a grid that includes "number of hours worked" how can I
have the totals dispayed on another form?
>
> ie:
>
> Record Form with Name, Date, Total hours
>
> Editable grid with Job1, Loacation1, hours as a row. When the row is
submitted hours field added to Total hours
>
> any help?
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|