ProgressiveTotal

[Guest]

My last project in the database I am building (thanks for all the assistance
so far!) is to build a form where Stats are entered. The idea is that the
project managers enter work in a month on a particular job in percentages.
Thus a job might already be sixty per cent done, and in the current month ten
per cent extra is done, so at the end of the month (ytd) there is seventy per
cent done. (There is a comments field for work undertaken that month, that is
the easy bit!)

The underlying table upon which the query is based has month field, actual
month work and year to date fields. I am not displaying the YTD on the form,
as I want it to be the total of previous work undertaken. But I am not sure
how to write the query. I have been trying to do a (sum of all the previous
months actual work) + the current month's actual work, but haven't got the
syntax right.

Any suggestions (apart from give up!) welcome.
Thanks

 

[Guest]

Hi suek,

Something like this:

select sum(ACTUALWORK) as TotalActualWork from TABLENAME
where PROJECTID = forms!FORMNAME.PROJECTID_FIELD

Hope this helps.

Damian.