how to use dlookup to retrive a value from more than one table
- Thread starter grad2009
- Start date
- Local time
- Today, 10:05
- Joined
- Sep 12, 2006
- Messages
- 16,052
but dlookup will only retrieve one value at a time
A DLookUp can retrieve multiple values from one table or query. However since it has only a single output value the multiple values must be combined in an expression.
eg:
Generally speaking, DLookups should only be used to retrieve a single value when it is not convenient to use a query. If a form is using multiple DLookUps consider trying to combine them into a query as the basis for a subform.
Each DLookUp is essentially a query so they can be slow if overused.
eg:
Code:
DLookUp("[field1]+[field2]","tablename",{condition})Generally speaking, DLookups should only be used to retrieve a single value when it is not convenient to use a query. If a form is using multiple DLookUps consider trying to combine them into a query as the basis for a subform.
Each DLookUp is essentially a query so they can be slow if overused.
