Syntax Error

[svsuthar1]

Can I know what I am missing in the following line of code

& "WHERE fldDate Between #" & strStartDate & #" and #" & strEndDate & #" _

 

[mwolf00]

& "WHERE fldDate Between #" & strStartDate & [red]#"[/red] and #" & strEndDate & [red] #"[/red] _

& "WHERE fldDate Between #" & strStartDate & [blue]"#[/blue] and #" & strEndDate & [blue]"#[/blue] _

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

Tsunami Relief Information​

 

[svsuthar1]

Thanks mwolf00 I really appreciated. I should have tried all the combination. I know it was with "#" signs I was not doing it correctly.

Thank you very much.

Samir