how do i look up the value of cell using access?

[kwokv616]

I have imported a number of tables into my access db, and i'm now writing a program that needs to look up values from these tables.

for example,
iif(fac<[value in third column 5th row], 1, 0)

how do i look up the value using access?

 

[pbaldy]

You can try a DLookup, but the concept of "5th row" isn't practical in Access. You can't count on the order of records in the table. You need the value of the key field that would identify that row.

 

[kwokv616]

Actually, columns are given names Y0 to Y99, while the first column is named "Age" with rows 0 to 70.
How can i lookup the value then with Dlookup?
for example, if i want to get r=(Y3, age=10)
thank you very much =)

 

[pbaldy]

Try

DLookup("Y3", "TableName", "Age = 10")

My gut tells me there may be a better table design. What do the columns represent?

 

[kwokv616]

Thank you very much it worked!! and its simple!!