It's very hard to tell what you've done incorrectly because you don't give any details of what you've done. But it sounds like reading about crosstab
queries might help you out.
-John
<cackerman@xxxxxxxxxxx> wrote in message
news:1135352783.644747.97190@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx >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.
>
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: Parameter box, complex query ... other queries are used in the crosstab their parameters must also be ... Select Query: Parameters from the Menu ... you are going to have to declare the parameters since you are ...regular queries and crosstab queries. ... (microsoft.public.access.queries)
Crosstab with parameter doesnt work ... I am building an application that presents data in the form of CrossTab... I need to parameterise these queries so I can filter out ... This is the simplest query in the application. ... (microsoft.public.access.queries)
Re: sorting by a formula ... Just create a new Row Heading in the crosstab with an expression ... Specifically what I have is a crosstab query with the first field ... query list the provider and then out to the side it list the total number ... has about 3 sets of formulas that total up the number of No responses.... (microsoft.public.access.reports)
