Access 97 Database Reports-Sedation

Cancelado Publicado Apr 13, 2007 Pagado a la entrega
Cancelado Pagado a la entrega

1. Aggregate Summary of Major Results- this report is correct. It filters and calculates correctly.

2. Patients with Adverse Outcomes- this report needs work. It shows the months and the data correctly, but where "Any Apparaent Adverse Event" is there is the number of cases with an adverse outcome and a percentage. The Number and the Percentage show for example (if you choose University all units for July 2006 to April 30 2007 the July 06- 2(1.9%) Sept 0(0%) <--- It is August that contains the zero but the Event header leaves out the month that does not contain data. I would like to see all the months listed for the date range selected. So, this would have July August (and the zero would be listed under the August). There will be no numbers underneath an item that is blank (meaning no data is submitted) or that has a zero. This report also needs to be able to be filtered with the report parameters selected.

[login to view URL] Variance- this report needs work. It shows the # of variances for all of the data in the database, it is not filtering for the date range and parameters selected. So, for example if you Choose University 1/1/2006-4/30/2007 (all units) you will see DR ID 2409 lists zero cases with a variance but 5 variance are listed. It looks like the variances are being pulled out of the database without the filter.

4. Review of Expected Process Elements- This report seems to be filtering correctly except I would like it to display all months in the data range specified even if there is no data (it would be the month with blank underneath).

5. I have a second database "Unit Level" with Unit Report for Physician, Unit Report for Nurse, and Unit Report for Outcomes that I need to replace the ones under the database "Test".

6. I need a report created and put in the drop down for the report selection with the parameters to include data entry report. I have a query listed "Data Entry Review", it just needs to be made into a report that can be found in the drop down selection with the parameters.

7. Finally, graphs are wanted to display each of the above reports (run charts for trending analysis). One graph should be "aggregate" of all radiology areas

the second graph should be a line graph, with each line representing a different diagnostic area. The metric should be: # variances reported/#total cases for month. If we put the aggregate data on one graph, that would mean we produce 3 flow graphs: MD aggregate & Nurse aggregate, MD by unit, Nurse by unit. If that last section makes sense to you thank goodness.. because I am having a hard time figuring out what this board is asking.

I had to delete data out of the database to get it to fit, and I couldn't upload the other database "UnitLevel" because of size.

Visual Basic

Nº del proyecto: #138526

Sobre el proyecto

7 propuestas Proyecto remoto Activo Apr 16, 2007

7 freelancers están ofertando un promedio de $91 por este trabajo

ajay192

Please see PMB for details.

$80 USD en 1 día
(3 comentarios)
3.6
adekwa

Please see PMB for details

$100 USD en 3 días
(1 comentario)
1.8
kamn1245

I am interested in this opportunity. I have about 9+ years experience working with access. Build many databases in access using visual basic & sql. Good experience with Excel too. I can help in automation of whole proj Más

$100 USD en 1 día
(0 comentarios)
0.0
Infominez

Hello, we have gone through the project requirement and very much interested to take up the project. Please check PMB. Best Regards, Infominez Team.

$100 USD en 5 días
(0 comentarios)
0.0
JeffPerson

50% on contract signing and 50% for project completiom

$90 USD en 15 días
(0 comentarios)
0.0
prateekpronoc

Customer Account and Product Management System worked on this project that is why this job is easy for me. your project profile is quite similar to CAPM

$95 USD en 2 días
(0 comentarios)
0.0
MJIqbal

We have done such small projects pretty quickly. We always deliver in time a fully functional and accurate software. If you need proper reports look no further. M J Iqbal

$75 USD en 6 días
(0 comentarios)
0.0