create a SQL report

IN PROGRESS
Bids
20
Avg Bid (GBP)
£44
Project Budget (GBP)
£33 - £56

Project Description:
I run a software called salon Iris. I want a custom SQL report to give me end of day totals.

I have an old report written in MS Access which did this function but now it doesn't work as the database structure in V9 of salon Iris has changed. If possible I don't want to have to install MS Access just to run this report.

Salon Iris allows custom sql reports in it's software, so maybe we now just need the report writing within salon iris in sql language. However I want it formatted for our ease, so be prepared to write a sql report that will run alongside the software and pull the information directly from the sql database.

You can check the database structure as Salon Iris is available for free download here v9.33 http://www.saloniris.com/supportdownloads.aspx

I have attached our old report that we used to use. I would like the same information on the new one.

Basically it's and end of day report with all our relevant information on it.

Our old programmer (10 years ago) used the existing software functionality to record the "cash starting balance" ( change in cash draw, which is not part of the takings)

This new sql report needs to be able to select the date you want to balance.
Add up all cash sales, all credit card sales etc. for that date
Take account of payments made from the draw (this is recorded in Salon Iris software so the information is in the database)
Take account of additional change put in the draw (this is recorded in Salon Iris software)
List that days transactions.
Then add the "starting balance" to the cash total (stating balance which was entered the previous day in Salon Iris) and now show the TOTAL amount of CASH IN DRAW so the cash draw can be counted and checked
The report should be able to be printed on A4

I am familiar with Salon Iris so I can direct you to the functions it has.

Skills required:
Database Administration, SQL
Additional Files: end of day report.doc end of day report.jpg
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


£ 50
in 3 days
£ 44
in 3 days
£ 62
in 3 days
£ 54
in 3 days
£ 63
in 3 days
£ 38
in 2 days
£ 50
in 3 days
Hire choks1991
£ 33
in 0 days
£ 55
in 3 days
£ 33
in 1 days