Access database tool
€8-30 EUR
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
Project ID: #20794371
About the project
Awarded to:
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
5 freelancers are bidding on average €43 for this job
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
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
Hi I'm MSAcess expert. I developed many MSAcess applications. Looking forward to work with you. Regards