Excel formula converting to Acces in Query

[Sjon1974]

All,
I am trying to create a query with a calculated field.

In excel it is easy, =g2+H3-I3

But how can i do this in a query, i am trying to get the value with Dlast and Dlookup but no succes yet

So i want the last value of the column Bancsaldo and add and retrect a value from the line below that. So i create a new Bancsaldo.

 

[xenou]

Hi, as a rule Access does not have any conception of "the line below". SO generally you have to work out your query expressions based on the data in the rows, not the location of the rows. If you have never used Access or worked with SQL before this will likely sound impossible. But it is hard to say precisely what would be the actual solution here without understanding the data and what is in the fields/columns you are working with and what is the structure in this table.

 

[Sjon1974]

The weird thing is that Access query can find values but i get a error from access that it cannot find that value.

 

[xenou]

That doesn't look like the proper use of the DLast function.
You can read up on the function here:

MS Access: DLast Function

This MSAccess tutorial explains how to use the Access DLast function with syntax and examples. The Microsoft Access DLast function returns the last value from an Access table (or domain).

www.techonthenet.com

 

[Sjon1974]

At the end, i created two Querys that ultimete gave me the result i was lookinbg for