Forms

[Tree]

Hi,
I am new to the forum and Access. I am trying to develope a form that has a running total of hours within a week or biweekly time frame I can do this with a query, howvever I would like this information on the data entry form also. I have

HoursPerWeek
Hcv hours
Total Hours worked

This calculation works fine. I have a subform that is used for data entry the above substracts the hcv hours from the hourperweek. Is it possable to keep this from doing a running total and just a weekly total without deleting prior data?

T

[VALIS]

Hi,
I am new to the forum and Access. I am trying to develope a form that has a running total of hours within a week or biweekly time frame I can do this with a query, howvever I would like this information on the data entry form also. I have

HoursPerWeek
Hcv hours
Total Hours worked

This calculation works fine. I have a subform that is used for data entry the above substracts the hcv hours from the hourperweek. Is it possable to keep this from doing a running total and just a weekly total without deleting prior data?

T

Is there a date field in your table?
If you're looking to show a weekly total you could create a control with something like the following as the control source

SELECT Sum([HoursPerWeek] -[Hcv hours]) AS [Total Hours worked]
FROM tblTableName
WHERE (((FldDate)>Now()-7));

This would display a last 7 days total

[PEB]

If I understand well you need The information of summed hours to be vizualized in a form in which you introduce information..

Also you achieve this calculation in a query...

So I suggest you to qreate a form that use this query...

Then this form have to be added as a subform to your form with the introduction of data..

Is it convinient for you?