Forms and Queries
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
I have created a form containing a list of questions that require only
Yes, No or N/A responses. I now want to query the results to display
each question with total Yes, No and N/A responses given for each
question. The query will not summarize the data the way I would like.
It contains numerous duplicates and is very difficult to follow. Any
suggestions?? I have a feeling I've created the tables incorrectly but
have tried every other way with no results.
.
Relevant Pages
- Re: REPOST: Problems with Text Box
... The first textbox permanently holds the total count of all responses. ... matching your criteria in the combo boxes. ... >>Hi James ... >>> Yes the query runs and returns a percentage... ...
(microsoft.public.access.formscoding) - Re: sorting by a formula
... to also divide the number of Nos by all responses ... in my original crosstab query and still display properly. ... Just create a new Row Heading in the crosstab with an expression ... displaying the provider and it is a row heading, ...
(microsoft.public.access.reports) - Re: Using DCount() to Display Counts of Zero
... the DCount function is not applicable in this case. ... the allowable Q9 responses. ... lookup table and the Q9 field in the RESULTS_BY_DATE_qry query. ... Steve Schapel, Microsoft Access MVP ...
(microsoft.public.access.queries) - Re: count if no record, then return zero value
... the DCount function is not applicable in this case. ... the allowable Q9 responses. ... lookup table and the Q9 field in the RESULTS_BY_DATE_qry query. ... Steve Schapel, Microsoft Access MVP ...
(microsoft.public.access.queries) - auto numbering primary key
... I am creating a new form from a query. ... Thanks for the previous responses to ... Linda ... Prev by Date: ...
(microsoft.public.access.forms) |
|
