Register and Join the most happening forum of Sikh community & intellectuals from around the world.
Discussion in 'Information Technology' started by Ashet, Jul 28, 2006.
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()
If you have a more involved scenario to model, this is a more in-depth
Lookup in a range of values in a query
If DLookup() nearly does it, but you need to specify which record to
retrieve, here's an enhanced replacement:
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Ashet" <Ashet@discussions.microsoft.com> wrote in message
Allen, you're a great help thanks. And from my home town too!