Đã hoàn thành

Access database tool

1) Require Home page: Import file button--gather input i.e. example Main Data File excel store into the table because of every week team will use this. Hence requires to compare data but requires to perform a query with a button in order to enter status in the column on the basis of criteria (maybe create another table).

2) Criteria of query:

Invoices new - Care ops comment empty (with latest dates over the week)

Invoices open for analyze - Care ops comment empty (all with new)

Invoices pending NSC - From supplier name: Volvo car Germany (without FINANCE-ownership)

Invoice pending DLR- From Supplier name: no Volvo car Germany or Choice, but the rest, everything from ownership, except Choice, Kalyan, Delia

Invoice pending Supplier - From Ownership, CHOICE and Choice/SP

Invoice pending Internal - From Ownership, excludes NSC, the rest and from ownership CareOps back office, fleet management, service planning, digital support

Invoice pending GFO - Ownership: Kalyan, Delia

Invoices handled - Ownership: Handled

Basically, writes the text in analysis

Invoices new

Invoices open for analyse

Invoices pending NSC

Invoice pending DLR

Invoice pending Supplier

Invoice pending Internal

Invoice pending GFO

Invoices handled total

on the basis of:

a) Care ops comment empty (with latest dates over the week)

b) Care ops comment empty (all with new)

c) supplier name - Volvo car Germany (without FINANCE-ownership)

d) supplier name - no Volvo car Germany or Choice, but the rest, everything from ownership, except Choice, Kalyan, Delia

e) CHOICE or Choice/SP

f) exclude NSC, the rest and from ownership CareOps back office, fleet management, service planning, digital support

g) Kalyan, Delia

h) Ownership - Handled

3) Report of statistics: Count of these mentioned below(per invoice date)

Invoices open to analyse

Invoices pending NSC

Invoice pending DLR

Invoice pending Supplier

Invoice pending Internal

Invoice pending GFO

Kĩ năng: Microsoft Access, Lập trình cơ sở dữ liệu, MySQL

Xem nhiều hơn: create access database vbs, create car booking access database, create report template via vba access database, access database macro create word document, create access database , create executable file access database, create access database table using, access database create table, create xml feed access database, create access database using visual basic net, program create csv access database, net create access database, create access project access database, create access database logistics, want create access database logistics company

Về Bên Thuê:
( 7 nhận xét ) Basel, Switzerland

ID dự án: #20794371

Được trao cho:

AntonSerg15

Hi How are you doing today? I have read your job detail very carefully and i have the confidenct to complete this on time perfectly. Although I am new freelancer but i have rich experience in this field. What is the m Thêm

€30 EUR trong 1 ngày
(0 Đánh Giá)
0.0

5 freelancer đang chào giá trung bình €43 cho công việc này

VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible Thêm

€30 EUR trong 2 ngày
(139 Nhận xét)
6.5
zu02

p.s. Can you specify a budget of this project? €8.00 – 30.00 EUR , it's unreal for your current project, maybe you meant for a hourly work? Hello I hope all's well with you. I see you'r looking for a developer pro Thêm

€25 EUR trong 7 ngày
(46 Nhận xét)
6.1
alhassanlatif

Hi, I am a professional Access developer I have done many projects in Access have a look at my profile. I have read your description could you contact me for details

€50 EUR trong 7 ngày
(7 Nhận xét)
3.5
MHassanBedor

Hi I'm MSAcess expert. I developed many MSAcess applications. Looking forward to work with you. Regards

€80 EUR trong 5 ngày
(13 Nhận xét)
3.6