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