jonamua1971
Registered User.
- Local time
- Today, 14:20
- Joined
- Mar 3, 2007
- Messages
- 97
First and foremost,Happy new year!!!
i have searched the forum and cannot to get my problem fixed.
i have a database that is currently running and i wanted to add something to it. By the way i got most of my help from this forum to build it. Thank you very much.
We would like to add a biling section to the database.
1.We receive payments from two types of people, out of which some make one payment and it covers the cost whilst others make two payment monthly to cover the cost.
its been difficult for us to tract those payment once they have been entered in the system. so i wanted to make a formula in queries to do the following.
Payee type one: PaymentA plus PaymentB= Amout received (850)
Payee type two: payment=Amt rec.(850)
if the amount is less than 850 or zero can i do a query to show all amt less than zero . Hope you get the picture!
thanks for inadvance fro any help.
i have searched the forum and cannot to get my problem fixed.
i have a database that is currently running and i wanted to add something to it. By the way i got most of my help from this forum to build it. Thank you very much.
We would like to add a biling section to the database.
1.We receive payments from two types of people, out of which some make one payment and it covers the cost whilst others make two payment monthly to cover the cost.
its been difficult for us to tract those payment once they have been entered in the system. so i wanted to make a formula in queries to do the following.
Payee type one: PaymentA plus PaymentB= Amout received (850)
Payee type two: payment=Amt rec.(850)
if the amount is less than 850 or zero can i do a query to show all amt less than zero . Hope you get the picture!
thanks for inadvance fro any help.
