Search results

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 =)

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?

I have a table with a number of fields and many records and I need to sum up the values of cells of a column that meets certain criteria (eg. column1=column2, iif(column3=0)) and then sum it up to become a value under a new column in a new table. I need to make a number of these new summation...

Basically, I've got an Excel spreadsheet with columns A-CX (with headings 'age' 'year0' to 'year100') and rows 1-72 (titles 'age' '0' to '70'), and I need to look up a value (a cell) from it and use it in Access. I have defined variables "iage" and "dur" (both integers) and I need to read the...

How do I lookup a cell value (given row number and column number) and return it to a variable? This is what I want to do: temp = table(row_number,column_number) I've searched through the internet and tried various methods and still cannot do it =( Please Help!! Many thanks!!

I'm writing some very simple codes that i'm quite sure are correct (at least i can't find out what is wrong with it =P) I'm trying to run the following: ------------------------------------------------------------------ Private Sub CSV_Click() Call CSV(Forms![ValMainScreen].[vdate].Value)...