how to use dlookup to retrive a value from more than one table

[grad2009]

hello guys,
can you tell me how to use dlookup function to retrive a value from more than one table.
i'm looking forward to hearing from you,
thanks with regard,

 

[vbaInet]

Base your DLookup on a query that draws from all those tables.

 

[gemma-the-husky]

but dlookup will only retrieve one value at a time

 

[vbaInet]

and it can be a tad slow

 

[Galaxiom]

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:

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.

 

[grad2009]

all thanks to you,