I have a table that list a bunch of QA results performed on different dates.
there are 9 yes questions and 9 no questions. each question has a weight. which is nto important right now.
what I am trying to do is get a total count for each question. I have the individual queries that give me the count for each question for each day.
What I can't figure out is to get the count of each question into one query without the counts changing. So what I tried to do is create a table (ztotalCashQtns ) that has the dates and then updated the each field where the dates are the same but the queries are not updatable. I need the results to feed to a report called (RQuestionsTota lCnt).
i am really struggling with this and have a 2 day deadline
there are 9 yes questions and 9 no questions. each question has a weight. which is nto important right now.
what I am trying to do is get a total count for each question. I have the individual queries that give me the count for each question for each day.
What I can't figure out is to get the count of each question into one query without the counts changing. So what I tried to do is create a table (ztotalCashQtns ) that has the dates and then updated the each field where the dates are the same but the queries are not updatable. I need the results to feed to a report called (RQuestionsTota lCnt).
i am really struggling with this and have a 2 day deadline
Comment