A simple question

[Steveanderson]

I'm using Access 2003
I have the field name and line number of the record from which I want to extract the value. (Basically X and Y coordinates to my table)
What is the synthax to assign this value to a variable
Thank you

 

[KenHigg]

You could use the dlookup() function. Search here or in Access for help on it.

 

[Steveanderson]

I'm not sure that the Dlookup works here
I want to assign the value of a specific record from a specific line in my table to a variable.
Here is the basic idea:

M = (table name).(Field name).(Line number)
M will give me the value of the cell at that specific line number

 

[boblarson]

When you say "line number" do you have a field named "line number?"

 

[Steveanderson]

Sorry for the lack of clarity
By line number I am talking about the record number

Knowing the field name and the record number how can I extract the value of the specific cell ?
I'm sure the answer is dead simple but I just can't find it.

 

[boblarson]

Just for your information - there is NO record number. What you see while on a form is a RELATIVE number. It does NOT identify a row of data. Data is not stored in any meaningful order in the tables. When you have a form with either a table or query as the record source, the "record number" is ONLY good for that particular session until the form is closed or the record source is requeried. It does not identify a particular record at all times. If you want a specific record then you should use something like an Autonumber field to give you an actual key you can use to identify that particular row of data.

 

[Steveanderson]

Thank you for the information. Indeed I will be using the record number in a specific session

The point of all this is to use records of a vertical table to create fields in a horizontal table. The horizontal table will be populated with data from a third horizontal table.

Maybe my approach isn't the best.