DLookup('field', 'table', ['condition'])

Hi,

I'm trying to create Domain Aggregate function that mimic Access' Dlookup
function, but without any luck, after digging (i think) all the docs
don't have the solution yet.

Syntax:
DLookup ('field', 'table|view', ['condition'])
where:field --               column name or calculation       table|view --condition (optional) -- SQL WHERE condition
withoutthe                 WHERE keywordIf the query returns multiple rows then it will only get thetopmost column.If
thequery retuns 0 rows then NULL would be returned
 


An example argument to the function would be
DLookup ('id', 'student', 'name=\'Bill Gates\'') --> '2001-432'


For now, I use some workaround for this, and it would be easier for me if
this function is present.


Hope u guys can help ;).  Thank u in advance



Herbert

--

MSU - Iligan Institute of Technology
Iligan City, Philippines