T
TAD from DBL
Is it possible in Excel to simply put criteria for a database query like
dsum(), dget(), davg() right in the query? For example, dsum(named
range,field name, criteria-right-in-the-query).
I am tired of laying out hords of query criteria in named ranges that I
refer to in just one query.
Is there a way to do this without vb macros?
dsum(), dget(), davg() right in the query? For example, dsum(named
range,field name, criteria-right-in-the-query).
I am tired of laying out hords of query criteria in named ranges that I
refer to in just one query.
Is there a way to do this without vb macros?