Hi all -
I was away from Access for several months so forgive me if I'm overlooking the obvious or using incorrect terminology.
I'm working on creating a database that will track all of our company's cell users and their charges. We pay for the voice plan, but they are responsible for all other charges. There are 3 types of charges
1. Recurring - same every month eg, text msg plan
2. Overage - not same every month, may not ever happen (eg over text plan)
3. Other - not overage or recurring - eg 411, equip charges
I do *not* need to track minutes for overages as we have a pool and have never gone over.
On the form, I would like to have a combo/list/checkbox something for the recurring charges. I would like to be able to choose whatever recurring charges exist for a user and then have that total added to that month's total for the user. I have to provide something to HR and the user to show the charges.
I have included the db so you can see what I am trying to do. I have downloaded the template Expense Reports and have been modifying it for our use.
I was thinking that the subform would be where each month I would add the current month's overages or other charges, and those charges would be filtered by date for the appropriate month's report (that *seems* reasonable and easy!).
And on the main part of the form, I could have an area where the recurring charges (the value of which does not change) could just be chosen and then would be added to the report. If someone adds a service, I just check the box - charge added until unchecked.
Thanks for any suggestions - I'm not sure if I'm going about this the wrong way or not.
Molly
ps - the data in there is from the template.
I was away from Access for several months so forgive me if I'm overlooking the obvious or using incorrect terminology.
I'm working on creating a database that will track all of our company's cell users and their charges. We pay for the voice plan, but they are responsible for all other charges. There are 3 types of charges
1. Recurring - same every month eg, text msg plan
2. Overage - not same every month, may not ever happen (eg over text plan)
3. Other - not overage or recurring - eg 411, equip charges
I do *not* need to track minutes for overages as we have a pool and have never gone over.
On the form, I would like to have a combo/list/checkbox something for the recurring charges. I would like to be able to choose whatever recurring charges exist for a user and then have that total added to that month's total for the user. I have to provide something to HR and the user to show the charges.
I have included the db so you can see what I am trying to do. I have downloaded the template Expense Reports and have been modifying it for our use.
I was thinking that the subform would be where each month I would add the current month's overages or other charges, and those charges would be filtered by date for the appropriate month's report (that *seems* reasonable and easy!).
And on the main part of the form, I could have an area where the recurring charges (the value of which does not change) could just be chosen and then would be added to the report. If someone adds a service, I just check the box - charge added until unchecked.
Thanks for any suggestions - I'm not sure if I'm going about this the wrong way or not.
Molly
ps - the data in there is from the template.
