Access Date Var Type Mismatch -SQL Stat. - TechRepublic
General discussion
February 7, 2002 at 06:07 AM
yatst

Access Date Var Type Mismatch -SQL Stat.

by yatst . Updated 24 years, 4 months ago

I am receiving a type mismatch error in SQL statement used for my recordsource. All fields are dates and the public variable is “as date”. Could you check my syntax and see if there is an error there or . . . . ?

& “WHERE (((labor.DATE)>= #” & RptBegDt & “#) AND((labor.DATE)<= #" & RptEndDt & "#)" _

This discussion is locked

All Comments