Between Satement

[teabags]

I am passing a sql statement through vb and I am getting a criteria mismatch expression.

Between '" & DStart & "' And '" & DFinish & "'

DStart and Finish both correspond to numeric fields in an access database

 

[pbaldy]

Numeric fields should not be surrounded by single quotes.

 

[Bodisathva]

...date literals need to be surrounded by '#'

i.e. a string representing today's date is

"08/01/2006" or '08/01/2006'

but a date object representing today's date is

 #08/01/2006#