Re: Forms and Queries

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.
>


.

Relevant Pages

  • 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)
  • Re: Make-table (?Materialized views?) of complicated cross tabs, calculated field
    ... be able to run fairly sophisticated queries in Access. ... The problem is I'm compiling about 10 fields of "1-5" rank responses ... I do the crosstab on that Union. ...
    (comp.databases.ms-access)
  • RE: Help with crosstab query
    ... arguments of Rate, BillType, Start_Date, End_Date, and NumWords. ... You can then use this function in the Value of the crosstab. ... Here is how I have been calculating values either in a select query or using ... I have successfully created three queries that return a month's ...
    (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)