I've built the following SQL in Access' query builder and seem to work fine when executing from the builder. When I try to place it into a script, I get an Error (Run-Time Error 13). I think I'm getting this error because what I'm trying to run is a parameter query, but I'm not quite sure how to fix it. I've tried a few things but still get the error.
SELECT T_AgileData_Parsed.Item_ID, Max(T_AgileData_Parsed.Line) AS MaxOfLine
WHERE (((T_AgileData_Parsed.Line) Like Int(Forms!F_DataReview_SI!F_AgileData_Parsed_sDS.F orm!line) & "*"))
GROUP BY T_AgileData_Parsed.Item_ID
HAVING (((T_AgileData_Parsed.Item_ID) Like Forms!F_DataReview_SI!F_AgileData_Parsed_sDS.Form! Item_ID));
I've attached an image of how I have the table setup if this helps.
Thank you for any help.