yeah u right that is a good one in Order Subform of the Northwind database
but i am not that much good in Coding .. i need somthing simple like we have
in Ms Excel like Vlookup function that we used or nested if function.
thanks
To do... what?
Excel is a spreadsheet. Access is a relational database. It is NOT "Excel on
steroids".
Most things that would use VLookUp in Excel can be done using a Query joining
tables in Access; in some cases it may make sense to use DLookUp. There is an
IIF() function which can be used for if/then logic, and quite a few other
options as well (either using query logic, or the Choose() or Switch()
functions).
If you would care to describe what you are trying to accomplish, and with what
as a basis, someone might be able to help. Right now we're in the position of
a doctor hearing a patient say "I don't feel right, doc, should I take an
antibiotic or an antipsychotic?"
John W. Vinson [MVP]
