Access database tool

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

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

Microsoft Access Database Programming MySQL

Project ID: #20794371

About the project

5 proposals Remote project Active 4 years ago

Awarded to:

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 More

€30 EUR in 1 day
(0 Reviews)
0.0

5 freelancers are bidding on average €43 for this job

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 More

€30 EUR in 2 days
(139 Reviews)
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 More

€25 EUR in 7 days
(46 Reviews)
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 in 7 days
(7 Reviews)
3.5
MHassanBedor

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

€80 EUR in 5 days
(13 Reviews)
3.6