Search results for query: *

oh, my gosh, tom, how did you do all that so fast!!!!! i printed what you sent so tomorrow i can sit down and really look this over. i am totally blown away! i just tried my database using the date aug03 and something isn't working. my calculations are right except for the first one! this is...

thanks so much for your help!!! i will be happy to answer any more questions! :)

the data type is numeric. in the query i have for a field - ERMONTH and in the criteria is have [forms]![er]![er] may03 is a month that i knew did not have many surveys so this has been the one that i have been playing around with to get this one hospital wide report. this is what my reports...

SELECT emergencyroom.ermonth, Avg(IIf([eroverallratingofcare]=1,0,IIf([eroverallratingofcare]=2,25,IIf([eroverallratingofcare]=3,50,IIf([eroverallratingofcare]=4,75,1000))))) AS MYercare...

table - emergencyroom field name - erinstructionscareforself field name - eroverallratingofcare field name - erlikelihoodrecomservices table - inpatientsatisfaction field name - psinstructionscareforself field name - psoverallratingofcare field name - pslikelihoodrecomservices table -...

I get so confused with all this! Sorry! The fields in the 4 tables are the same. The problem with the union query is that one table only has two of the questions whereas the other 3 tables have the 3 questions. All my calculations are working correctly. I am just now stuck on the step of...

the common field that links the table would be the date (month/year). in my query I have built an expression to get the averages into my report which is working fine. here is an example of what is in my query - MYercare...

No, I am not using subreports. I created a query from the 4 tables pulling the three questions from the tables that I needed into my query. From this I created the one report. One survey I know has 30 surveys for May03 and 141 for August 03. Does this help you any??? Thanks!

I have 4 tables for surveys and have created individual reports for the surveys. Now I was asked to created one report by pulling several questions from each of the tables. I now need to get the total number of surveys from each table for each month. I have the total number of surveys working...

thanks, i will try!:) this may be long! tbl-emergencyroom fieldname-erinstructionscareforself fieldname-eroverallratingofcare fieldname-erlikelihoodrecomservices tbl2-inpatientsatisfaction fieldname-psinstructionscareforself fieldname-psoverallratingofcare fieldname-pslikelihoodrecomservices...

Can anyone help!! I am trying to get the total of 3 fields from 4 tables into one report. I can get the total of each field correct in a report by itself, but I can not get the 3 fields to add together so I can pull this into one report. This is so frustrating! I am working on 4 surveys that...