How to refer to fields from another record?

[waltern]

HI
New to access
I'm in field c record x
i want to make calc from fields a,b,c from some records before x and write infield f
how i refere to this fields???
thanx

 

[dmckinney]

if at all possible you don't.

9 times out of 10 an improved db design will save you having to do this. Or is yours the 1 in 10?

 

[waltern]

On 2003-01-06 07:57, dmckinney wrote:
if at all possible you don't.

9 times out of 10 an improved db design will save you having to do this. Or is yours the 1 in 10?

I have to make calc becouse it refer to a average from some fields before!!!

 

[Tanis]

If you must put the results of a calculation in a field then put this code in the After Update event procedure of field c

Me![f] = Me![a]+Me!+Me![c]

I have assumed you are adding the fields. Change the operand where necessary.


David