Recent content by dennisr

Thanks Taruz, that worked. I never would have figured that ( a running sum for a query or form) out on my own.

Access 2003 - each record has how much is added or removed from inventory. On the form (or query) I want to enter a starting inventory amount and have the running inventory show at each record row. Easy to do in excel but how can I do it in Access? Inventory = Previous Inventory + added -...

Trevor, Thanks that worked.

I have a continous form with the displayed row collected from the union of three queries. On each row there is a control to open an approprate form (not subforms) for editing the row based on its source. This all works well except for reflecting the change on the calling ("main") form. I...

Steve, thanks for replying. What I need in my database datasheet is basically a running balance for a selected recordset. The records are by date order and each one (row) shows product added or used for the day and an table field for manual adjustment. I need the day's current product...

have a form (or query) where each record need info from one field of the previous record for a calculation. How do I get the previous record field info?