Search results

it works MStCyr, It works. Thanks.

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

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

Ok I'll try that, KeithG. Thanks

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.

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.

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

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

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.

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

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

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

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.

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

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?

Entering loan and payment information I have created two form one for entering loan information and one for entering payment information. The form to enter loan information is based on a query (the query is base on tblBorrowers and tblLoans). The form to enter payment information is base on a...

I am creating a money loan database and I would like someone to give me some advise here. I have created three tables for this money loan database as follow: tblBorrowers BorrowerID LastName FirstName PhoneNumber tblLoans LoanID LoanDate LoanAmount BorrowerID tblPayments PaymentID Interest...

I really appreciate it Seargent, I just want to let you know that it worked like a charm. I really want to thank you for your help. The only thing I needed to add to your code was declaring the i variable and make the changes that you suggested. I was trying to find a solution to this...

I have search this forum but I have not found a solution to this problem. Ok, I have a form with a combobox and a listbox (multiselect). I want to append the combobox's value in a table based on the records I select in the listbox. So, If I select 3 records in the listbox and then I select a...

Thank you for your help I figured this out already.