Compare a Column for Same Member ID & Run Total Of Their Investmen

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Query, I have a database with many members in it and their individual
investment deposit records that they have made during say a 1 year period.

Now, I have to tally the total investments made by each individual member
and display it as such: Member ID, Last Name, First Name, and Investment
Total.

I have set up the query design but I don't know how to set up the
"expression" statement and/or criteria.

HELP!
 
In Query, I have a database with many members in it and their individual
investment deposit records that they have made during say a 1 year period.
Click to expand...

What is the structure of these tables? Hopefully you have two tables
in a one to many relationship, members 1:n deposits - but you don't
say.
Now, I have to tally the total investments made by each individual member
and display it as such: Member ID, Last Name, First Name, and Investment
Total.

I have set up the query design but I don't know how to set up the
"expression" statement and/or criteria.
Click to expand...

Since I don't know what expression you want, nor what criteria you
want to apply (because you haven't said), I don't know how either. All
I can suggest is that you use a Totals query using the Greek Sigma
icon on the toolbar; Group By the memberID and name fields, and Sum
the investment amount.

John W. Vinson[MVP]
 
Back
Top