If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
monthly report
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. |
#2
|
|||
|
|||
monthly report
You've described queries, forms and reports.
"Where's the beef?" None of those work unless there's data "underneath" them. Your "how to" question depends on how you've structured your data. -- More info, please ... Jeff Boyce Office/Access MVP "Database User" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a Monthly Report | SLA | New Users | 7 | April 6th, 2010 04:49 PM |
Set up a report using more than one query | jbeck2010 | Database Design | 6 | February 12th, 2005 06:59 AM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |