If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Total of one cost-field??
I need advice on working with Access 2000.
I've got a database of house repair records stating the cost of each repair. Am going nuts trying to figure how to add all the records of this one cost-field to got a total sum of repairs. Can anyone help? -- Best Regards, GBL ΤΏΤ |
#2
|
|||
|
|||
Total of one cost-field??
Look up the Dsum Method in help. The following is an=20
example of credit card amounts being totaled from the=20 table "tblCredit_Card_Details" you can output this to a=20 form or report. DSum("[curCredit_Card_Amount]", "tblCredit_Card_Details")=20 Hope this Helps Les -----Original Message----- I need advice on working with Access 2000. I've got a database of house repair records stating the=20 cost of each repair. Am going nuts trying to figure how to add all=20 the records of this one cost-field to got a total sum of repairs. Can=20 anyone help? --=20 Best Regards, GBL =D4=BF=D4 . |
Thread Tools | |
Display Modes | |
|
|