Any idea why this won't work?
It says the expression you entered contains invalid syntax. You may have entered an operand without an operator. It then focuses on yyyy
If I run it like this it works
and this also works
Any help would be great my brain hurts.
Code:
SELECT Max(Val(Right([ClosedNumbers]![ClosedNumbers],4))) AS Expr2
FROM Closednumbers
WHERE (((Left([ClosedNumbers]![ClosedNumbers],2)) Like "Str(Right(DatePart("yyyy",Now()),2))"));
It says the expression you entered contains invalid syntax. You may have entered an operand without an operator. It then focuses on yyyy
If I run it like this it works
Code:
Str(Right(DatePart("yyyy",Now()),2))
Code:
SELECT Max(Val(Right([ClosedNumbers]![ClosedNumbers],4))) AS Expr2
FROM Closednumbers
WHERE (((Left([ClosedNumbers]![ClosedNumbers],2)) Like "20"));
Any help would be great my brain hurts.