The data tends to be stored differently in a database than in a spreadsheet,
but DLookup() is the basic function for retrieving a value from a table. For
help with the arguments, see:
Getting a value from a table: DLookup()
at: http://allenbrowne.com/casu-07.html
If you have a more involved scenario to model, this is a more in-depth
approach:
Lookup in a range of values in a query
at: http://allenbrowne.com/ser-58.html
If DLookup() nearly does it, but you need to specify which record to
retrieve, here's an enhanced replacement:
ELookup()
at: http://allenbrowne.com/ser-42.html
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
