Write some Software

I use a software called salon Iris. I want a custom Access / 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 new V9 of salon Iris has changed. I have attached the MS Access form with all the code and logic from the old report. I don't want to have to install Full MS Access on every computer, just to run this report. It would be preferable that this a 'stand alone app' or it uses the free MS Access viewers. Be prepared to write a report that will run alongside the salon Iris software and pulls the information directly from the sql database. You can check the database structure as Salon Iris is available for free download here v9.33 [login to view URL] you will note that db that salon iris uses is put in a folder in SQL Server Basically it's an end of day report. It needs to be printed on A4 and keep track of how many times the report is run each day so I can check what the staff did to make the till balance at night . I have attached a printout of our old report that we used to use. I would like the same information on the new one. I would like the report all on one page (a maximum of 2 pages on a very busy day which has more information) so any tables will need to be side by side to fit. Our old programmer (10 years ago) used the existing salon iris functions to record the "FLOAT for next day" (Float is the change in cash draw, which is not part of the takings) This new report needs to:- Be able to select the date you want to run the report on. Have the operator declare how much cash and coins have been counted in the draw, before the report runs Use the code and logic supplied, in the files attached to:- Add up all cash sales, all credit card sales etc. for that date Take account of payments and receipts 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 and is in the db) List that days transactions. List data pulled from the db Add the "FLOAT for next day, 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 This should be a stand alone app with the viewer embedded or it your report requires a report viewer, that it launches the viewer automatically. I am familiar with Salon Iris so I can direct you to the functions it has. Please see the zip file attached containing 1) The printout of the report (end of day report. jpg) 2) The report frm which created the report (reception till accdb) This has all the code and logic, which created that report. 3) The temporary mdb ) that the report used to use (stats only [login to view URL] I can give you the actual database we are using with real data after the project is awarded.