Re: Please Help with Query Calculations

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.

"Jerry Whittle" <JerryWhittle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E7ACD203-9AA7-4D67-98CF-D76F77CCAEC1@xxxxxxxxxxxxxxxx
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.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Chris Peikert" wrote:

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.





.

Relevant Pages

  • Re: Doctors Income
    ... That you pose the query you do in the vague/open-ended form in a way ... Even way out here in the bowels of fly-over country, I'm often pleasantly surprised to discover the depth and breadth of info that the libraries place at my fingertips. ... Of course, every other budget cycle the libraries are targets for the politicians who want to spend the money on sexier projects, so vigilance is always necessary. ...
    (soc.retirement)
  • Re: Update Query & Expression Help
    ... AccountID integer, ... Qtr1 money, ... > I have a Query I want to run, to update a field in the MASTER table. ... > examine 4 fields each record of MASTER to find the Highest Max value; ...
    (microsoft.public.access.queries)
  • Re: My design - where did I go wrong?
    ... > money S1, ... Is it the combination of CustID and SaleDate? ... then the query will be as fast as possible. ... beyond the 4th decimal is lost in a money data type, ...
    (comp.databases.ms-sqlserver)
  • Re: Time fields
    ... Put two calculated fields in the query: ... time difference and the other to calculate the money. ... <MS ACCESS MVP> ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Duplicate Records From a Table
    ... You're right on the money with what I want. ... >>> I'm trying to find duplicates within a table where a field name called ... >>> I want the query to show me all FIVE records because they are all alike ... >>> within the first nine digits. ...
    (microsoft.public.access.queries)