![]() It correctly differentiates a Null and a zero-length string.(Note that if you are retrieving a value for every row of a query, a subquery would provide much better performance.) It runs about twice as fast as DLookup().That means you can specify which value to retrieve: the min or max value based on any sort order you wish to specify. An additional optional argument allows you to specify a sort order.It returns the wrong answer if the target field contains a zero-length string.It does not clean up after itself (can result in Not enough databases/tables errors). ![]() after compacting a database, if the table contains no primary key). You may even get inconsistent results from the same data (e.g. Since you cannot specify a sort order, the result is unpredictable.
0 Comments
Leave a Reply. |