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!