date range on a summary

[Guest]

I have a table with expense details *EmployeeID, Amount, Company,Date*. A
table with Employee info *EmployeeID, First, Last, Address, Supervisor*. A
table with supervisor info *SupervisorName, BillingNumber, Dept*and a Dept
table which really just has 1 column list of depts.

What I want to do is create two queries *to then use as reports* that will
show first just the 8 depts and what they spent and then a second one that
will show the depts with a list of supervisors

Dept1
Doe,John 40.00

where the 40 dollars might come 3 different employees. This I can handle but
when I try to limit the time frame it stops being a summary and shows
Doe,John however many times with each expense.... how do I get it to
summarize just certain info..

Ryan

 

[John Spencer]

In the query, change Group By to Where under the date field.