Query only runs in Design Mode

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This query runs great in Design Mode
It runs only once after Query compiles, subsequent runs return Numeric Field
Overflow error. The [US PUB DATE] FIELD IS 10 CHAR TEXT 'MM/DD/YYYY'

SELECT IsDate([US PUB DATE]) AS Expr1
FROM [Trade Book]
WHERE (((IsDate([US PUB DATE]))<>-1));

Any Ideas?
 
This query runs great in Design Mode
It runs only once after Query compiles, subsequent runs return Numeric Field
Overflow error. The [US PUB DATE] FIELD IS 10 CHAR TEXT 'MM/DD/YYYY'

SELECT IsDate([US PUB DATE]) AS Expr1
FROM [Trade Book]
WHERE (((IsDate([US PUB DATE]))<>-1));

Any Ideas?
Click to expand...

Try

SELECT <some fields you want to see>
FROM [Trade Book]
WHERE NOT IsDate([US PUB DATE]);


John W. Vinson [MVP]
 
Back
Top