Set a Variable in VBA to be Used in SQL

[cynicon]

Hi, everyone

So this is really simple,

I have an Access Table called "BDAXA", where there are many records, and a column called "Date".

I use an imput box called (DAT) where I ask the user an especific month to generate a query in a format "mmyyyy", so lets say the user writes 022010, then DAT = 022010,

I need to know how can I use that variable (DAT) in the sql languaje

strsql = SELECT BDAXA.Fecha
FROM BDAXA
WHERE (((BDAXA.Date)=DAT));

[mshmyob]

Try

strsql = "SELECT BDAXA.Fecha FROM BDAXA WHERE (((BDAXA.Date) = #" & DAT & "# ));"

cheers

[cynicon]

Thanks so much mshmyob, you are really kind thanks for your answer, thanks thanks thanks, see ya

[NeoPa]

That will often work but not always.

Check out Literal DateTimes and Their Delimiters (#) for a fully portable solution.