Hi, I want to take data from AX co

[ersatz]

Hi,
I want to take data from AX column,from AX_dec table, for Date=Now():
My code is like that:

SQL = "SELECT AX from AX_dec where Date=Now()"
Set r0 = db.OpenRecordset(SQL, dbOpenDynaset)

I retrieve this error:
Run-time error '3061'
Too few paraameters.Expected one.

Can somebody help me?
Regards,
ersatz

 

[mwolf00]

If your database is access try:

SQL = "SELECT AX from AX_dec where Date=#"&Now()&"#"


for SQL Server:


SQL = "SELECT AX from AX_dec where Date='"&Now()&"'"

 

[ersatz]

thanks very much mwolf00.
it work greate!