Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. accountinggeek

    HELP! Dlookup

    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
  2. accountinggeek

    HELP! Dlookup

    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'...
  3. accountinggeek

    HELP! Dlookup

    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
  4. accountinggeek

    HELP! Dlookup

    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...
  5. accountinggeek

    HELP! Dlookup

    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...
  6. accountinggeek

    dlookup Help please- Access 2000

    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
  7. accountinggeek

    dlookup Help please- Access 2000

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

    dlookup Help please- Access 2000

    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...

Part and Inventory Search

Back
Top