putting criteria directly into a database query, dsum, daverage, e

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?
 
H

Héctor Miguel

hi, !
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?

you might want to give a try to ms-query ? (data > get external data)
- build the query
- assign certain parameters to cells
- modify "the cells" (or parameters)
- refresh yur query

hth,
hector.
 
T

TAD from DBL

Hector, I tried this but MS Query doesn't seem to let me use SQL functions
like CURRENT_DATE. Can't figure it out. everytime I try to use a function
like this it spits it out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top