Search results

Can you tell me why this SQL does not return dates that are of the same date, ie. two Pacer New procedures done on 1/12/2009. The SQL only returns one of the procedures. I have attached the output from this query and the out put from a query that just pulls the data not involving quarters...

Just to be clear, 'AND' is not a function that can be used in a criteria? Is that correct?

I'm not experienced enough to understand what I should replace the %$##@_Alias with, or do I? Access is stating that there is an invalid backeting of name 'SELECT PacrorICD, New Implant TRANSFORM Sum([%$##@_Alias].CountOfNewImplantOrGeneratorChange) AS NumberOfProcedures SELECT [PacerorICD]...

I have a db with patient names that appear multiple of times with multiple different procedures. Is it possible to query all patients who have had procedure X AND procedure Y AND procedure Z? Using AND in the criteria returns no data.

Where you have placed the [dateofprocedure] in the quarter value fields, I need the 'count' of procedures placed under each quarter, ie. how many 'pacer new' procedures were done in Q1, Q2, etc and how many 'pacer change' procedures were done in Q1, Q2. Is this possible?

I do use Access reports. I just figured out to export the report in rich text. Is that what you are looking for? The query is working fine in that it is selecting the data and identifying the quarters correctly. Two things:How do I get a report to list the procedure name as the row heading and...

If I group the New or Change column by count, the results is incorrect information. SQL from what I think you suggested: SELECT [Pacer QA tbl].DateofProcedure, [Pacer QA tbl].PacerorICD, Count([Pacer QA tbl].NewImplantorGeneratorChange) AS CountOfNewImplantorGeneratorChange FROM [Pacer QA tbl]...

I'm sorry, I do not understand the implication of the question. I work for AnMed Health Heart & Vascular. I am working on information that will help with our accreditations.

I exported some of the data to excel. Will this work?

I exported a portion of the query to excel. Will this work?

I have an Access DB query that returns the following results by using this formula, Qtr: DatePart("q",[DateofProcedure]). I need a report that will count how many of these records are in each quarter and by running quarter. Our quarter one is Oct, Nov, Dec. Please show me how to do this...

I am a little confused with the Microsoft explanations of DatePart. Would you mind typing out the formula for an example? I've tried the DatePart("q",[DateofProcedure])=1 in the criteria of the Qtr One column. When I saved the query and opened it again, access threw the...

I have an Access db that contains DateofProcedure_________Procedure Type 1/2/2009_______________ ICD 3/2/2009_______________ Pacer 5/2/2009_______________ ICD 8/2/2009_______________ Pacer Please show me how the criteria would look to query a total of procedures by each quarter of the year.