calculation formulas in access

[Hovoruha Octavian]

Hi,

I'm trying to build an calculated expression, in a table/query, similar to what you can see attached (view jpeg in att.)


Any ideeas on how can I do it?

[John_G]

Without using a fairly complicated VBA function, you can't. Access is not like Excel, i.e. it is not a spreadsheet - it cannot reference "cells" or "ranges of cells", even in datasheet view.

Access can refence data in the current record ( = row) fairly well, but outside of the row, no.