I have a table of employees, a table of expenses of those employees, a table
of supervisors of those employees and a table of departments that those
supervisors are in. I made a query that prompts you for an employee's name
and a date range *the dates are in the expense table*. It then itemizes all
expenses by that employee. I can't figure out how to then create an query
that will then show a list of employee summaries that will take a supervisors
name and return an list of employees and their total expenses... I then want
to summarize that by department but I think those two are connected..

If someone *say an mvp* reads this and decides not to post could they
mention if there is something wrong with my post? I used to have really good
discussions on here and my last few posts have gotten nothing.. not sure if
posts are confusing *being confused about an issue leads to confused posts..*
or if I have missed some ettiquette........

Thank you,
Ryan