Search results

Ok, I've got that part figured out. I had to take the field 'date of procedure' out of the aggregate query. I now have one page in the report showing all of the complication fields and the count of complications for each type. But now I need to get a percentage of complications by dividing...

I tried each field in a group header. The attached is the way it looks now. It is still repeating the information. How do I stop this?

The fields are in the detail section. Do you mean to make a separate group for each of the 9 fields using the Sorting and Grouping.

I have a query that is pulling 463 records of dates and then the data is either a 1 or 0. 1 = Yes, 0 = No. SELECT [Pacer QA tbl].Pneumothorax, [Pacer QA tbl].PericardialEffusionTamponade, [Pacer QA tbl].HematomaRequIntervention, [Pacer QA tbl].Other, [Pacer QA...

When I drop the complications report into the volume of cases report, is it dropped in the detail section? I need to resolve another problem with the report that is being dropped and I don't know what is wrong. The report is a one page report but when the report is viewed, the one page is...

In this query I need to report on Volume of cases and Volume of Complications. My problem is I do not know how to add the Complications to the report. I have tried creating a group header for the different complications but that results in the data being placed on the report mixed in with the...

Re: Forcing a by quarter query to show 0 when applicable What is wrong with this? I am trying to make this query show a zero if the quarter does not have any data. An error message states the select statement includes a reserved word or an argument name that is misspelled or missing, or the...

Brian, in this query that you helped me with, can you tell me what to put and where to put it in the query to make it place a zero in the quarters that do not have data? Returns the correct number of records in each Quarter. SELECT [Pacer QA tbl].DateofProcedure, [Pacer QA tbl].PacerorICD...

God Bless you! I could not figure out where to place the Count(*). This is working now. Thank you so very much. I have a lot of work to do now!!:)

I don't have to show individual records, but the count does have to include all records. That is my problem. I cannot get the report to show me that there are 60 records. The report continues to show that there are only 51 records. I know you must think that I am a complete dummy with this...

This is a very large db. I need to pull out the procedure date, whether or not the procedure is ICD or Pacer, whether or not the procedure was New or Changed and to group the date of procedures by quarters, with quarter one starting in the months of 10, 11 and 12. If you can tell me an...

So what is needed in the query to make it return the 60 records. I need a report that will reflect the count of 60. I'm sorry but I am just lost with this. I know your information is correct but I just do not understand what to adjust with the query to make it return the 60. Do you mind...

This sql brings in 60 records: SELECT [Pacer QA tbl].DateofProcedure, [Pacer QA tbl].PacerorICD, [Pacer QA tbl].NewImplantorGeneratorChange FROM [Pacer QA tbl] WHERE ((([Pacer QA tbl].PacerorICD)="ICD") AND (([Pacer QA tbl].NewImplantorGeneratorChange)="New")); This sql brings in 51 records...

The query is not returning all of the data. Don't I have to resolve that before I try to count? There are more than one occurrence of date 3/24/2009 but the query only returns one occurrence. How do I resolve that?

I am editing the SQL bringing in the quarters, correct? This is the sql changing per your suggestion (I think) SELECT [Pacer QA tbl].DateofProcedure, IIf(Month([DateofProcedure]) In (10,11,12),"Quarter 1",IIf(Month([DateofProcedure]) In (1,2,3),"Quarter 2",IIf(Month([DateofProcedure]) In...

That does not make the query select all of the occurrences that have the same date. This is only counting what the query selected.

Can you please tell me why this query will not count all of the occurences that exist in a quarter. The query counts only one occurrence of each date, ie., if there are two or more occurrences of 3/24/2009, the query only counts one occurrent vs, two or three occurences. SQL: SELECT [Pacer QA...

Can you tell me what to put in this query to make Quarter 1 appear with '0' data if there is not data in the quarter? TRANSFORM Count([ICD UPGRADE Total Volume qry].PacerorICD) AS CountOfPacerorICD SELECT [ICD UPGRADE Total Volume qry].NewImplantorGeneratorChange, Count([ICD UPGRADE Total...

Thank you. I accomplished the 'group by' on the report side. I'll keep your suggestion though, as this is going to be a hughe every growing project.

Please show me where the group by clause should be in this SQL. Group By Patient_Name SELECT [Pt_Test Listing].MPI, [Pt_Test Listing].Patient_Name, [Pt_Test Listing].Procedure, [Pt_Test Listing].[Service Date], [Pt_Test Listing].Dept, [Pt_Test Listing].Category FROM [Pt_Test Listing] WHERE...