2. What is the highest (Max) Salary in each department Fields included
3. What is the total (sum) Employer contribution by department.
Tables

you're gonna need a max(*) and group by. what attempts have you made?

Yeah I went there earlier but i am still confused >.< Your inbox is full

look up youtube vids for group by. getting an answer isn't gonna help you. you need to understand what the group by does.

/edit you shouldn't be pm'ing me. stick to the topic.

This post was edited by carteblanche on Mar 29 2015 09:20pm

It's for access

doesn't matter. you said you don't understand GROUP BY. GROUP BY is the same across all relational DBMS. the only thing that differs is syntax. if you understand it in mysql or sqlserver or oracle, then you'll be able to understand it in MS Access