Simple in Excel, Hard in Access, referring to other lines

[Bill Bisco]

Dear all,

I'm trying to replicate a bit of Excel Code in Access, but for the moment I'm stumped.

The above code refers to cells in other rows to get its values. Is there any way for Access to do something similarly? If so, how?

Sincerely,

Bill

 

[pr2-eugin]

Hello, How are you trying to manipulate this information is it via a Form/Query/Report?? Above all What exactly do you want to do??

 

[mdlueck]

So, in the context of a Multiple Items form, perhaps? I believe you may refer to adjacent field on that type of form based on syntax:

Me.fldName.Value

to refer to those other fields of the current record.

Oh... seems I glanced too quickly. It appears from the Excel example you provided you not only wish to refer to adjacent fields of the same row, you wish to refer to other rows. I have never attempted such with an Access Multiple Items form.

 

[Bill Bisco]

Dear all,

Thank you for your replies. I am just providing a simple example of what I'm trying to do. I need to create a new field based on the values of fields in other data rows. I wanted to use Access to do this, and I was curious if there was a method available to do so.

Hope that clarifies,

Bill

 

[mdlueck]

I need to create a new field based on the values of fields in other data rows.

In a Database Table?

In a Multiple Items Form?

In a Report?

Is the calculate value to be saved? Or for display-only?

 

[Bill Bisco]

In a Database table yes.
The Calculated value has to be saved.

 

[pr2-eugin]

In a Database table yes.
The Calculated value has to be saved.

Think again??

It might seem to be important that you save but might not.. What if the next field is deleted? Where will it lookup to?