Sum of fields/records

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.
 
M

[MVP] S.Clark

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 

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

incorrect query results when joining tables 4
Exclude fields after SELECT * 5
Adding fields in a subform 1
Calculating amount due using changing rates 1
Display a total in a report 12
Calculations in Reports - adding two totals 1
Sum Expression 2
Count text values in a Access Field 0

Top