QUERY TOTAL PROBLEM ACCESS 2000

[FLOYDBIRTH]

Hello
Haveing a mind blank or bad day. i have a Access 2000 database. one of my querys is I have a query that i am trying to get a running total or total field in the query. tried the d sum fuction but not working at all. The query fields are
Tech num
Tech name
Inv num
Date
Job Done
Labor Paied Tech ( this is the field in the query from the main table that i am trying to total in the query)
Have done it before but can not find notes, compltely drawned blank. Any help on this will be very much welcomed.
Thank You
FLOYD

 

[dhookom]

I would just do this in a report with a running sum.
You can use a subquery to get the "running sum":
SELECT tblA.*,
(SELECT Sum(LaborPaiedTech)
FROM tblA A WHERE A.TechNum=tblA.TechNum and A.[Date]<=tblA.[Date] AND A.InvNum <=tblA.InvNum) as TotPaid
FROM tblA;

Make sure you test this...

Duane
MS Access MVP
Find out how to get great answers faq219-2884.