Access help please

[DiskDoctor]

Hi guys, hoping someone can help me out.

I have a table called "COLLECTIONS" in MS Access XP with Six fields: "ID",
"NAME", "DATE", "GST", "CR", and "DR". The table will contain all
transactions for different customers.


I made a form and imported the "NAME" field from "COLLECTIONS" table. I
want to make a three text boxes that displays the totals of "GST", "CR" and
"DR" for each name (customer). What do I put in the control source
property? Must be a SUM statement.

Any help appreciated

 

[DiskDoctor]

sorry wrong group

 

[aaron.kempf]

congrats!!

you're going down the best path; Excel sux.

you would want to store these calcs in a table; and then allow them to
select the other 3 boxes... or something along those lines.

tell us more about your table design-- i dont know the diff between
GST, CR and DR-- what do these mean?