Sum of fields/records

  • Thread starter Thread starter catherine
  • Start date Start date
C

catherine

I have a table (Tblfees) which has FeeID as the Primary
Key and Fees (Text Field) as a List of possible fees.

TblFees
FeeID Fees
1 $90.00
2 $125.00
3 Waived

Is there a way to calculate a total fee charged to a
person? For example, a person may be charged for two
items or more so their record would have:
ItemName 90.00
ItemName 125.00

So I would like a total calculated to show $215.00. Is
this possible with the Fees Field being Text? Thanks so
much.
 
In the fees table, a waived fee, I assume, would be $0.00. Put that in the
field, instead of "Waived" and you will be able to perform the summary.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top