Help needed in this query - Plzz someone help me

nrmarthi

Registered User.
Local time
Today, 09:10
Joined
Feb 13, 2006
Messages
47
SELECT (Max(ReferenceDescription.ReferenceID))
FROM (ReferenceDescription)
WHERE (ReferenceDescription.ReferenceID >= (ReferenceDescription.CategoryID * ReferenceDescription.DepartmentID) AND ReferenceDescription.ReferenceID <= (INT(ReferenceDescription.CategoryID * ReferenceDescription.DepartmentID * 0.9999))
 

Users who are viewing this thread

Back
Top Bottom