Please Help with Query Calculations

  • Thread starter Thread starter Chris Peikert
  • Start date Start date
C

Chris Peikert

I have a database where people have a case number and under each case number
is several dates of when people were billed money and paid money. I created
a query to show the dates, and amounts owed. Then a seperate query to show
dates and amounts paid. The problem Im having is even though I formated the
dates column by year if there is multple entries in the same year it will
not total them. So if there is money paid several times in 1998 then it will
show 1998 over and over each time with its own money. How do I make it show
1998 one time with the funds >0 totaled? Then I will go back and do the same
with the other query <0 totaled. I am having to do this across 20 years.
 
You are on the right track with the word "Total". While in the design view
of the query, go up to View and select Totals. Group By the year field (and
maybe a few more fields) and an Sum the Amounts Owed and Amounts Paid fields.
 
I have it totaling and under date it says "Group by" but not sure what to
put there. As for the other fields I put SUM but its not summing them up.
Its still showing multiple years.
 
Back
Top