sql query in excel
Perhaps if you posted a little more of your SQL code and told us what kind of
database (Oracle, MS Access, SQLServer, etc) you're accessing, we'd have a
better chance of helping.
***********
Regards,
Ron
"ivan" wrote:
i've tried but didnt work, i've tried with getday,now,etc
thanks a lot for your help
"Ron Coderre" wrote:
Ivan
Nothing's really wrong. That's just a notice from MS Query that it can't
represent the RunDate field in a table so it can't show you the query
graphically. From that point on, you'll need to edit the query via the SQL
window.
Does that help?
***********
Regards,
Ron
"ivan" wrote:
Thanks ron, but doesnt work, it says that cant show that query graphically
"Ron Coderre" wrote:
Try this in your SQL code:
Date() as RunDate
Does that help?
***********
Regards,
Ron
"ivan" wrote:
im triyn to retrieve data to excel with the microsoft query
can you help me with the function to get the day i run the query?
get day() doesnt work.
a query error appears!
|