Occurs when I add a Val criteria
This is OK
SELECT Val([1stWeek]) AS Expr1
FROM tblMain
WHERE (((tblMain.[Date Entered])=#11/10/1990#));
but this reports an error
SELECT Val([1stWeek]) AS Expr1
FROM tblMain
WHERE (((Val([1stWeek]))=46) AND ((tblMain.[Date Entered])=#11/10/1990#));
This is OK
SELECT Val([1stWeek]) AS Expr1
FROM tblMain
WHERE (((tblMain.[Date Entered])=#11/10/1990#));
but this reports an error
SELECT Val([1stWeek]) AS Expr1
FROM tblMain
WHERE (((Val([1stWeek]))=46) AND ((tblMain.[Date Entered])=#11/10/1990#));