Build Database and Reports Using Date Formulas -- 3

キャンセルされた 投稿 Jan 14, 2016 着払い
キャンセルされた 着払い

Daily, Weekly, Monthly Yearly, Variance, Average

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

マイクロソフトアクセス レポートライティング アプリ用ビジュアルベーシック

プロジェクトID: #9324069

プロジェクトについて

13個の提案 リモートプロジェクト アクティブ Jan 17, 2016

13人のフリーランサーが、平均$198 で、この仕事に入札しています。

zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc もっと

$246 USD 3日以内
(45件のレビュー)
6.1
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ もっと

$30 USD 1日以内
(30件のレビュー)
4.5
esalem

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and もっと

$368 USD 15日以内
(3件のレビュー)
4.4
y2klewis

HI, my name is Daniel, i am an access expert and vb programmer, i have a good experience developing access application (including all kind or reports), i am sure i can do this work really fast, and 100% according to yo もっと

$100 USD 3日以内
(13件のレビュー)
3.9
pegasus9529

This is definetly my main skill which is modify data for all variant of date function. Let's discuss for this project, i am waiting for good news from you. Thank you.

$225 USD 7日以内
(レビュー1件)
3.2
vw1702486vw

I have read your requirements.. Please open chat to discuss. =============================================================================

$311 USD 15日以内
(2件のレビュー)
0.7
haseriki2001

I believe i am the best candidate for this project because of my hands on experience in using Microsoft Access and I can deliver the project in good time

$155 USD 7日以内
(レビュー1件)
0.6
zbyszek22

I have extensive background in designing and supporting number of various MS Access Databases in field of Health Care, HR, Retail, Municipal and other. My knowledge of MS Access range from designing data entry forms もっと

$223 USD 7日以内
(0件のレビュー)
0.0
bulaerashid

Dear Client, I am developing database in MS Access for the last 14 years. I have good command in VBA. I am confident to do your work in time. Please provide some sample of your requirements. I can star your もっと

$111 USD 7日以内
(0件のレビュー)
0.0