Recent content by accountinggeek

PHV You did it!!!! Thank you so much- worked like a charm!!!! BTW- MS is like a gang that can't shoot straight. You just wouldn't beleive what I've been through. THANKS THANKS THANKS

Hi John; Adding that subquery simply returns the value column name, not the corresponding value in the column that I am trying to fetch. For example- value = apples; i am looking for the number in the record that corresponds to the column. With the sub query, the column is returning 'apples'...

John; Thanks so much! I will check it out and let you know how it goes. You might have saved what was looking like a bad weekend! Henry

1) unique_val is the primary key; 2)Here goes(note that I was using an example- I query many fields) SELECT henrybak.Value, henrybak.unique_val, [Value] & [ID] AS Expr1, DLookUp([henrybak].[Value],"henrybak",'unique_val') AS [Money], henrybak.TRANID_TRN, henrybak.ID, henrybak.ACCRBAS...

I still can't figure out the problem. And MS tech support doesn't seem to have the answer either. Anyway, I modified my table to make it completely flat, so no other tables are involved. So, now I have the following table: ID-------Value------UniqueVal-----Cost--Quantity--MarketVal...

I've given that a try already, but maybe I am doing something wrong. I'll keep playing and will let you know how it turns out. THANK YOU VERY MUCH FOR YOUR HELP

here it is: dlookup(lookup_value,tablename) should give me the return_value

I have a single table with over thirty columns of numeric data. The first column is a text description of the field I want to lookup. So as an example, I have: ID Lookup_Value Return Value Quantity Cost 1 Quantity 100 100 80 1 Cost 80 100 80 2...