Concluído

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

Habilidades: Microsoft Access, Programação de Banco de Dados, MySQL

Veja mais: 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

Acerca do Empregador:
( 7 comentários ) Basel, Switzerland

ID do Projeto: #20794371

Concedido a:

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 Mais

€30 EUR em 1 dia
(0 Comentários)
0.0

5 freelancers estão ofertando em média €43 para esse trabalho

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 Mais

€30 EUR in 2 dias
(139 Comentários)
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 Mais

€25 EUR in 7 dias
(46 Comentários)
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 dias
(7 Comentários)
3.5
MHassanBedor

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

€80 EUR in 5 dias
(13 Comentários)
3.6