Nicholson, Karen
cyx5 at cdc.gov
Mon Sep 27 05:33:12 CDT 2004
I have an Access front-end and am querying an SQL backend. When putting in a select statement in the query, all is fine if I specify a date of say, less than today or <date()... However, if I try to specify a particular date, I get an sql overflow error. The syntaxes I have tried include: <#9/27/2004# <'9/27/2004' <'20040927'. Any clues? Thanks. Karen Nicholson National Laboratory Xerox Global Services