Access Query - Admissions by Day and Month
$10-30 USD
Πληρώθηκε κατά την παράδοση
Hello,
Using the attached database and validation spreadsheet, I need 2 queries created that will accurately account for admissions by day and by month.
Additionally, the sum of admissions per day need to match month end when you sum the days within the month.
An admission occurs on the earliest POSTINGTIMESTAMP when QTY = 1. A QTY -1 represents a reversal.
The results of query 1 (admissions by day),
POSTINGTIMESTAMP, DEPT, FINANCIALRECNUM, QTY
The results of query 2 (admissions by month),
POSTINGTIMESTAMP, DEPT, FINANCIALRECNUM, QTY
In the validation spreadsheet, you will notice what the expected value for the month is... your query needs to provide that for the given month of the postingtimestamp.
Let me know if you understand and can get this done.
I need this ASAP.
Ταυτότητα Εργασίας: #5361392
Σχετικά με την εργασία
6 freelancers κάνουν προσφορές κατά μέσο όρο $45 για αυτή τη δουλειά
Dear Sir, I'm expert at access, talent with VBA,I'm interested on doing your project,with money back grenture, but i know that you will like my work. Kind Regards, NourElDeen
I am available right now. I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, Περισσότερα
hi i read your project details. but there is no attached files found. please attach the required files. i am ready to undertake this
I have read the task description carefully in which you have required a person who can consolidate data in excel and ms access by creating query according to your need. I have just Run a query in ms access to get ou Περισσότερα