How to enter a parameter into the sql statement

[almagir]

Hi,

I've this query with an sql statement:
= Odbc.Query("dsn=churrera", "sel top 10* from dwpryvp0.jnfs_territBO_vent_v_new where fx_anno=2016")

I would like to insert the year (2016) through a parameter.

I've created the parameter "year(2016)" but I don't know how to define it in the sql statement.

Thanks in advance

[radpir · Accepted solution]

hi almagir,

try the following:

= Odbc.Query("dsn=churrera", "sel top 10* from dwpryvp0.jnfs_territBO_vent_v_new where fx_anno=" & year)

regards,

konrad

[almagir]

Hi Konrad,

It has worked as you told me.

I've had to convert the number 2016 to text.

Thanks for your help.

Regards