Query only runs in Design Mode

[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?

 

[John W. Vinson]

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?

Try

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


John W. Vinson [MVP]