Add a running total field to a query containing only 1 table

[Robin Fairchild]

I have the following fields in a table (tbl_Budget_Checkbook) and I need to
create a query that adds a Cumulative total (CUM_TOT) column for the project
number and month:

PROJ_NO MONTH_YEAR MTHLY_BUDGET
CUM_TOT
MD101 012008 $1000
$1000
MD101 022008 $1500
$2500
MD101 032008 $0
$2500
MD102 012008 $20000
$20000
MD102 022008 $5000
$25000

The table also has an ID field as the primary key. How can I make this
work? I need it in the query instead of a report because this data will have
to be further linked to other tables, etc. and may be downloaded to Excel
periodically also.

Thanks for any help you can give me!

 

[Allen Browne]

See:
Subquery basics: Year-to-date
at:
http://allenbrowne.com/subquery-01.html#YTD

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...