Another question for Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three fields in Form View:
Loan Amount
Added Fees
Loan Amount Total

I wish to have, in form view, the Loan Amount Total add the 2 previous
fields. Can anyone please explain to me how to do this?
 
If you have Loan Amount Total in your table, that is not correct. Doing that
jeopardizes your data integrity. You should delete it. Base your form on a
query that includes Loan Amount and Added Fees. Put the following expression
in a blank field in your query:
Loan Amount Total:[Loan Amount] + [Added Fees]

Another observation ---
The design of your tables may not be correct. You should have something
like:
TblLoan
LoanID
LoanDescription
LoanDate
LoanAmount
LoanTermMonths

TblLoanAddedFee
LoanAddedFeeID
LoanID
AddedFeeDescription
AddedFeeAmount

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
To handle the possibility that Added Fees might be null, you should use the
Nz function:

Loan Amount Total:[Loan Amount] + Nz([Added Fees], 0)

I agree that a second table is likely more appropriate. Of course, the query
would then need to join the two tables together, and use the Sum function on
the AddedFeeAmount field. Again, if it's possible that there aren't any
added fees, remember to use a Left Join so that you get all rows from
tblLoan, whether or not there are matching rows in tblLoanAddedFee.


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Steve said:
If you have Loan Amount Total in your table, that is not correct. Doing
that jeopardizes your data integrity. You should delete it. Base your form
on a query that includes Loan Amount and Added Fees. Put the following
expression in a blank field in your query:
Loan Amount Total:[Loan Amount] + [Added Fees]

Another observation ---
The design of your tables may not be correct. You should have something
like:
TblLoan
LoanID
LoanDescription
LoanDate
LoanAmount
LoanTermMonths

TblLoanAddedFee
LoanAddedFeeID
LoanID
AddedFeeDescription
AddedFeeAmount

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)



Dave said:
I have three fields in Form View:
Loan Amount
Added Fees
Loan Amount Total

I wish to have, in form view, the Loan Amount Total add the 2 previous
fields. Can anyone please explain to me how to do this?
Click to expand...
Click to expand...
 
Steve,
Thank you for your reply.
I have continued in the way that i was going and have placed a query as you
suggested. This has worked fine, even with the fact that sometimes the added
fees are £0.00.
I have bashed about with this for a quite a while now and seems to hold up,
so once again thanx

Steve said:
If you have Loan Amount Total in your table, that is not correct. Doing that
jeopardizes your data integrity. You should delete it. Base your form on a
query that includes Loan Amount and Added Fees. Put the following expression
in a blank field in your query:
Loan Amount Total:[Loan Amount] + [Added Fees]

Another observation ---
The design of your tables may not be correct. You should have something
like:
TblLoan
LoanID
LoanDescription
LoanDate
LoanAmount
LoanTermMonths

TblLoanAddedFee
LoanAddedFeeID
LoanID
AddedFeeDescription
AddedFeeAmount

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)



Dave said:
I have three fields in Form View:
Loan Amount
Added Fees
Loan Amount Total

I wish to have, in form view, the Loan Amount Total add the 2 previous
fields. Can anyone please explain to me how to do this?
Click to expand...
Click to expand...
 
Back
Top