I am trying to creat a database/ spreadsheet that will track a customer list and services provided for each client. Once the data/ clients is all entered, I need to be able to have multiple functions that will sum up what each clients owes. I can not really preform this on excel. Is access the right program for this? Also is there any tips or tricks that will help me in this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Right program?
- Thread starter AustinL
- Start date
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,377
- Office Version
- 365
- Platform
- Windows
AustinL
It's hard to tell without more information, including an idea of what data you are using, whether Access is the best tool for this job.
You can easily summarize data in Access but in Excel you could probably do complex calculations easier.
It's hard to tell without more information, including an idea of what data you are using, whether Access is the best tool for this job.
You can easily summarize data in Access but in Excel you could probably do complex calculations easier.
Upvote
0
The data I will have is:
customer name
service provided
billable hours
rate /per hour
each entry may occer on different days and times however at the end of the month i need a function that will search through find, and total each customer name's total bill. then be able to check off if they have been billed and if they have paid.
customer name
service provided
billable hours
rate /per hour
each entry may occer on different days and times however at the end of the month i need a function that will search through find, and total each customer name's total bill. then be able to check off if they have been billed and if they have paid.
Upvote
0
Andrew Fergus
MrExcel MVP
- Joined
- Sep 9, 2004
- Messages
- 5,462
- Office Version
- 365
- 2021
- 2016
- Platform
- Windows
Have you looked at using the 'Time and Billing' wizard database that ships with Access? If you open Access, create a new database based on the wizard template - I think the process varies for each version of Access but it might be worth looking at. Even if it doesn't track the amounts outstanding, the wizard has done most of the hard work and then it would be a matter of building in receipts and balances owing.
HTH, Andrew
HTH, Andrew
Upvote
0
Similar threads
- Solved
