Complex Query

[Nigel]

I am trying to model a form and add some calculations from a spreadsheet,
when a record is updated the record needs to carry out a series of
calculations

here is an example of the spreadsheet formula

=ACOS(COS(Z15-Z14)-SIN(Z14)*SIN(Z15)*(1-COS(AA15-AA14)))

To try and make things easy I have named the fields on the form the same as
the columns ie A to AD, but as you can see the formula referances a value in
the previous record same field

Anyone have any idea how I would do this

thanks

 

[strive4peace]

Hi Nigel,

in Access, you need a way to REALTE to the previous record... do you
have a sequential field or a date where you could define a relationship
to the previous record that you want?


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Nigel]

So there is no way I an do this with code then

Hi Nigel,

in Access, you need a way to REALTE to the previous record... do you
have a sequential field or a date where you could define a relationship
to the previous record that you want?


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[strive4peace]

Hi Nigel,

in Excel, the row relates to the previous row because of the row number,
which you can and do reference... you can do something like that in
Access, but you need to STORE what you are going to use to relate
info... that is why I asked about what field you will use.

Of course, it can be done -- and you will HAVE to use code if you don't
store something that you can relate in a query... I was just trying to
make it easier for you...


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*