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.
--
Please contact me by email if you have an answer to this question. I
appreciate it.
"Héctor Miguel" wrote:
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.