Go Back   Talk Microsoft > Microsoft Operating Systems & Software > Microsoft Office Family

Reply
     Microsoft Access question?  
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-17-2007, 04:40 PM
Junior Member
 
Join Date: Nov 2007
Posts: 6
Default Microsoft Access question?

How can I write a query in Microsoft Access that references the row above it?

Specifically, I have a table that looks like this:
Row 1: 7
Row 2: 1
Row 3: -3
Row 4: -6
Row 5: -2
Row 6: 9
Row 7: 10

I want to write a query that will calculate a running total, but will never go negative. So the results would be:
Row 1: 7
Row 2: 8
Row 3: 5
Row 4: 0
Row 5: 0
Row 6: 9
Row 7: 19
Reply With Quote
Links
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 01:27 AM.