Recent content by aerofuego

  1. A

    border on report

    it works MStCyr, It works. Thanks.
  2. A

    border on report

    is it possible to have a border around the whole report? thanks
  3. A

    Late payment fees

    not the solution KeighG, I don't think what you suggested is the solution. This is basically what I'm trying to accomplish: Report's Header Late Fee: If the late fee is $10, how can I show $20 here?) Regular Payment: Amount Due: Due Date: Pmt# Pmt Date...
  4. A

    Late payment fees

    Ok I'll try that, KeithG. Thanks
  5. A

    Late payment fees

    Help So, nobody knows how this can be done? I thought someone would be able to at least give me some directions as to how this can be done. Thanks.
  6. A

    Late payment fees

    No solution, yet. Can someone help me out with this problem? (see post #3). Now, how can I do this based on Moniker and KeithG posts? Thanks.
  7. A

    Late payment fees

    sound good How can I achieve what I wrote on post #3 based on your suggestion?
  8. A

    Late payment fees

    database design KeighG, thanks for the reply. OK, my database is setup as follow: tblCustomers cusID cusFName cusLName CusPhone tblLoans LoanID cusID LoanDate LoanAmount FirstPmtDate LatePmtFee etc... tblPayments pmtID LoanID pmtDate pmtAmount LatePmtFee etc... Let me know if you need...
  9. A

    Late payment fees

    need help on this one If anyone could give me at least some directions as to how I can accomplish this, I would appreciate it. Thanks.
  10. A

    Late payment fees

    Thanks moniker for your reply. This will be as you mentioned in the first paragraph. Now, lets say someone has to pay me $50 every month with a late fee of $20. If that person doesn't pay me for three months, then he/she will owe me the following: Payment: $150 Late fees: $ 60 Total Amount...
  11. A

    Late payment fees

    I have one quick question, Is the late payment fee part of the Payments table or does it belong to a different table? I have already posted here http://www.access-programmers.co.uk/forums/showthread.php?t=122393. Thanks
  12. A

    How to apply late fee?

    I have searched and found nothing that can help me out this. OK, I already have the following table setup: tblPayments PmtID PmtDate pmtAmount LatePmtFee loanID etc... I lend someone an x amount of money to pay me an x amount of money every week over a period of time. The interest will be...
  13. A

    How many tables would be needed...

    I'll try your suggestion I'll give it a try and see how it works out. I might have more questions but for now let try this out first. Thank you for the reply.
  14. A

    How many tables would be needed...

    How many tables would I need for the following: Order# customer date/time order received date/time order due courier (the order might be shipped via two or more different couriers) dept (the order might be sent to three different depts.) the order will be for making photocopies of different...
  15. A

    Referential Integrity

    Entering Payments Lets say there are 50 borrowers and 75 loans. How do I know that loan #37 is for borrower #43 and not for borrower #13?
Back
Top Bottom