Hi All
I am very new to access but I was wondering if there is any way to write query which would give me the bottom ten records per branch/category. I am able to get top/bottom ten Unknown Loss Values Sum out of the whole database but I want that for each branch.
SELECT UXW1.JOURNAL, UXW1.[Branch Code], Sum(UXW1.[Unknown Loss Value]) AS [SumOfUnknown Loss Value]
FROM UXW1
GROUP BY UXW1.JOURNAL, UXW1.[Branch Code]
HAVING (((UXW1.JOURNAL) Is Null));
Is this possible?
Kindest regards
Emerson