Help needed urgently - whats wrong in this SQL statement

[nrmarthi]

SELECT (Max(ReferenceDescription.ReferenceID))
FROM (ReferenceDescription)
WHERE (ReferenceDescription.ReferenceID >= (ReferenceDescription.CategoryID * ReferenceDescription.DepartmentID) AND ReferenceDescription.ReferenceID <= (INT(ReferenceDescription.CategoryID * ReferenceDescription.DepartmentID * 0.9999))

 

[Pat Hartman]

Except for having unnecessary parens, nothing stands out. Are you getting an error message or is it just not working? If it is not working, try breaking it into two queries.
query1:
SELECT ReferenceID, CategoryID * DepartmentID As EXP1, INT(CategoryID * DepartmentID * 0.9999) As EXP2
FROM ReferenceDescription;

Query2:
Select Max(ReferenceID)
From query1 where ReferenceID >= EXP1 AND ReferenceID <= EXP2;