Built-In Formula in Access Db not working

[rdyson39]

I am trying to get the last column of a pre-formatted db to provide a total. I have tried unsuccessfully to correct the issue myself but after 1 month of nothing I'm coming for professional help. I need the Total of the donations received to show. There is a drop box where I can choose count or number and neither of these is what I want or need. Thank you in advance! Ruth

[June7]

Are you trying to emulate a Split form with two subforms bound to the same dataset?

So why can't Sum be used on Donations field? Why is this data seen as text and not number?

Why use CCur() function instead of Format property to format data?


I know there is Count function but what is Number?

[Gicu]

Hi Ruth,

Instead of doing the calculation in the subform's control try to move it to the subform's record source; if it is based on a table create a query and add your CCur(Nz(.... formula as a calculated field then bind the AmountRaised textbox to the calculated field. If still no luck please try to upload a stripped down version of your db so we could have a look.

Cheers,
Vlad

[ssanfu]

Suggestions:

Use only letters and numbers (exception is the underscore) for object names.
Do not use spaces, punctuation or special characters in object names.
Do not begin an object name with a number.
Do not use Look up FIELDS, multi-Value fields or Calculated fields in tables.


If the field "ID" is an Autonumber type, it should not be displayed on the form; it should be hidden.
"ID" is a poor name - a better name would be "DonationID". I would use "DonationID_PK".

"Name" and "Description" are reserved words in Access and shouldn't be used for object names.

[rdyson39]

This database was prebuilt. I am only trying to use it until we purchase a program which will meet all our needs. I don't know why Access built it the way it is. I'd change whatever is necessary. I'm only presenting what was already done. Your continued support is appreciated.

Ruth

I am trying to get the last column of a pre-formatted db to provide a total. I have tried unsuccessfully to correct the issue myself but after 1 month of nothing I'm coming for professional help. I need the Total of the donations received to show. There is a drop box where I can choose count or number and neither of these is what I want or need. Thank you in advance! Ruth

[orange]

I empathize with your situation, but Access is not the culprit -- some one used the tools provided by Access - and built the database. If it doesn't provide the info it is/was suppose to provide, then there is a design issue. Access did not do the design.

I don't know why Access built it the way it is.

June has asked good questions that should be answered.