 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / July 2007Another question for Access 2003
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 resource@pcdatasheet.com >I have three fields in Form View: > Loan Amount [quoted text clipped - 3 lines] > 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? 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.  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) > 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 [quoted text clipped - 30 lines] >> 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? 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 > 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 [quoted text clipped - 30 lines] > > 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? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.