So there is no way I an do this with code then
"strive4peace" wrote:
[Quoted Text] > 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 wrote:
> > 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
> >
>
|