Access help please

D

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
 
A

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get a running total for DR and CR 2
Running balance for debit and Credit using query in Access 2007 0
Please help 1
REALLY NEED HELP 1
Help creating a search form in Access XP 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Please help me choose a product for the task 2
Delete all data after a symbol in a field 0

Top