Please help

[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

 

[Ken Snell [MVP]]

Use a query as the record source for the form; let the query do the summing.
Then you can bind the three textboxes to the respective sums.

Also, do not use Date, Name, etc. as the name of a table's or query's field.
They and many other words are reserved words in ACCESS, and can create
serious confusion for ACCESS and Jet. See these Knowledge Base articles for
more information:

List of reserved words in Access 2002 and Access 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/?id=321266

Special characters that you must avoid when you work with Access
databases
http://support.microsoft.com/?id=826763