Daily, Weekly, Monthly Yearly, Variance, Average
Make sure database run correctly. Please check out the formula
[login to view URL]!39146&authkey=!AC8JonpG30EkDeo&ithint=folder%2c
I’m looking for someone that is very fumier with Microsoft access date formulas . I would like to have a Microsoft access 2013 database built that will take my table that consist of years of data that I can update the database daily
I would like following reports created
Group by
ClientName
ClientNumber
Sub Grouping
CollectorNumber
CollectorName
DateofPayment
Then vice versa
Grouping
CollectorNumber
CollectorName
Sub Grouping
ClientName
ClientNumber
DateofPayment
I also attached a screen shot of what my other data base looks like that I'm hoping if functions the same.
When creating the database only use working days and remove holidays
Reports
1. MTD
2. Previous Month
3. Previous Week Monday, Tuesday Wednesday, Thursday, Friday
4. YTD
5. Prior Years
6. Variance
7. Average
8. Monday Collector/First of the week
9. Tuesday Collector/Second day of the week
10. Wednesday Collector/ Third day of the week
11. Thursday Collector/Fourth day of the week
12. Friday Collector/Firth day of the week
13. Variance
14. Average Daily
15. Week1
16. Week2
17. Week3
18. Week4
19. Variance
20. Average Weekly
21. Average Collectors by week to week
22. Average Collectors by Month to Month
• Report for the following 7 Data Points (2014 Q1, Q2, Q3, Q4 and 2015 Q1, Q2, Q3)
• Data points. (Quarter one = Jan-Mar; Q2 = Apr-Jun; Q3 = Jul – Sep; Q4 = Oct – Dec)
• Once this is completed I would like to create four presentable reports
I have some Report templates that I would like to be used, with an understanding that you may have to add another sub row grouping and sorting.
Need to create a table that allows me to Group and Sort Clients and Collectors.
Will need to look at Database by Deign View
With the exact structure for my incoming placement but now I was one built for the Collection side. I can show you the one I have if it helps,
But you need to be very good at date formulas
Good in MS Access .i make sure all reports will be generated according [login to view URL] in datbase schema(ER,RDBS, Normalization) and MySQL queries like(Insert, delete, update, DDL, Triger, DML, etc).
Good in C# and java language.
Further details in chat box
$25 USD en 1 día
5,0 (3 comentarios)
2,7
2,7
2 freelancers están ofertando un promedio de $73 USD por este trabajo
Hello, I am an academic writer and database designer and manager having worked with the software well over seven years. I have been the architect if numerous databases and have a reputation of delivering to the best expectations of my clients. Kindly contact me for a superb design and timely delivery