G
Guest
i'm making a database for a fitness club and there all different membership
types
annual - they pay once a year
quarterly - they pay 4 times a year
Monthly - pay every month
etc. etc.
I'm making the monthly invoice so all i did was based it on a query of all
people who's current payment method is monthly. Then on the report i put in
an unbound box this code = "your membership of $12.50 for " & [Please Enter
the Month You Require] & " is now due"
then when i run the report i get asked Please Enter the Month You Require
and i fill it in. I then have calculated fields adding up what they owe from
previous months.
This works great and all the monthly people get invoiced the only problem is
what if they have paid already an invoice for them will still come up?
I need to add something in the query that the month that i enter in the
report anyone registered for that month and amount outstanding is $0.00 ie
he's paid should not come on the list? how can i do this
Just to give a bit more information - when i record a payment i find the
members name in the main payment form and i then have a subform with the
following entries.
Month - this has a combo box and i select the correct month e.g July 05
Membership Type - this is defaulted to the current membership type in the
members table so i dont have to fill it in - it says monthly already.
Amount Owing - this shows up automaticaly based on a table.
Amount Paid - this says $0.00 and i have to fill this in.
Amount Outstanding - this is a calculated field of Amount Owing - Amount
Paid so no filling in needed.
types
annual - they pay once a year
quarterly - they pay 4 times a year
Monthly - pay every month
etc. etc.
I'm making the monthly invoice so all i did was based it on a query of all
people who's current payment method is monthly. Then on the report i put in
an unbound box this code = "your membership of $12.50 for " & [Please Enter
the Month You Require] & " is now due"
then when i run the report i get asked Please Enter the Month You Require
and i fill it in. I then have calculated fields adding up what they owe from
previous months.
This works great and all the monthly people get invoiced the only problem is
what if they have paid already an invoice for them will still come up?
I need to add something in the query that the month that i enter in the
report anyone registered for that month and amount outstanding is $0.00 ie
he's paid should not come on the list? how can i do this
Just to give a bit more information - when i record a payment i find the
members name in the main payment form and i then have a subform with the
following entries.
Month - this has a combo box and i select the correct month e.g July 05
Membership Type - this is defaulted to the current membership type in the
members table so i dont have to fill it in - it says monthly already.
Amount Owing - this shows up automaticaly based on a table.
Amount Paid - this says $0.00 and i have to fill this in.
Amount Outstanding - this is a calculated field of Amount Owing - Amount
Paid so no filling in needed.