Calculate cell with cell above

B

BlindPro

Registered User.

Local time

Yesterday, 22:59

Joined

Jun 16, 2012

Messages

40

• Jul 30, 2012

• #1

Hi,
I have a table look like this

I want to calculate cell with cell above

Fist record 1000
Second record 1000+1200 = 220-
third record 2200+1000 = 3200
forth recrod 3200 + 1500 = 3700

I want to do this with query, It is possible??

thanks for your help

 

John Big Booty

AWF VIP

Local time

Today, 15:59

Joined

Aug 29, 2005

Messages

8,262

• Jul 30, 2012

• #2

So long as your record ID remains sorted in ascending order and there are no breaks in the series, you could use the DLookup() function to return the previous number and add that to the current record.

 

B

BlindPro

Registered User.

Local time

Yesterday, 22:59

Joined

Jun 16, 2012

Messages

40

• Aug 1, 2012

• #3

No ID is not sorted in ascending and contains duplicate, Please help how can I do this??

 

G37Sam

Registered User.

Local time

Today, 09:59

Joined

Apr 23, 2008

Messages

454

• Aug 1, 2012

• #4

Yes you can, what exactly do you want to achieve out of this?

Try:

Code:

Dim startID as integer, endID as integer
startID =0
endid = 5
msgbox Dlookup("sum(Salary)","table1","ID > " & startID & " AND ID < " & endID)

 

B

BlindPro

Registered User.

Local time

Yesterday, 22:59

Joined

Jun 16, 2012

Messages

40

• Aug 4, 2012

• #5

still in trouble please help

 

B

BlindPro

Registered User.

Local time

Yesterday, 22:59

Joined

Jun 16, 2012

Messages

40

• Aug 4, 2012

• #6

Oki, John Big Booty Now I have ID column that sorted ascending and have not any bread, how can i do it with DLookup?? I tried a lot, but I couldn't

I used this:

Code:

Total: [Salary]+DLookUp("Total","Query2","ID=" & [ID]-1)

 

B

BlindPro

Registered User.

Local time

Yesterday, 22:59

Joined

Jun 16, 2012

Messages

40

• Aug 4, 2012

• #7

Hey I Did it

with this Code:

Code:

Total: IIf([IDD]=1,[Salary],DLookUp("Total","Query2","ID=" & [ID]-1)+[Salary])

Thank you Very Much