If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"dynamic" column lookup
I need to use the value in one field to determine which column in another
table needs to be used to retrieve the corresponding value. In detail, I have a table which has different values for each time period for each day of the week, e.g., Monday from 9-12 has one value, Tuesday from 3-6 has another value, etc. resulitng in 8 values for each day for a total of 56 different values (columns). These values are different for each record. Based on a time stamp, I need to identify which column I need to use for a value. For example, if the result of my time stamp is Friday 9-12, then I would like to be able to do something like - Value = Table_Name.Column (Friday 9-12), where Friday 9-12 is the results of my time stamp analysis. Is this possible? I am looking for something similar to the Indirect function in Excell. Any help would be much appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
LookUp Values That Depend on Previous Column | Simula67 | Database Design | 3 | January 21st, 2005 09:09 PM |
How can I sort an entire spreadsheet from a list | prod sorter | Worksheet Functions | 4 | November 17th, 2004 03:43 AM |
Printing 2 column vakues from a Lookup Table | iccohen | Setting Up & Running Reports | 1 | August 12th, 2004 03:35 AM |
Make a field lookup dependent on the value in another field of a record? | Susan A | Database Design | 8 | May 22nd, 2004 09:10 PM |