Crosstab Query - Table Fieldnames as Row Headings

[DoDo1975]

I am trying to make a crosstab query by using the field names from a table as my row headings. I cannot figure out what to put in the QDE pane to make this happen. Any help would be appreciated.

 

[67peshawar294]

1975,
First, you need at least 3 entries in the qbe for a crosstab to function.
1. one "row heading"
2. one "column heading"
3. one "value"

In the qbe grid select the field you want for the row heading. In the "crosstab" heading select "row heading"
Select the field you want for the column heading and select "column heading".
Select the field you want for the values to be displayed and select "value".
You can have other values like totals if you select "row heading" for that field.
jim

 

[DoDo1975]

Sorry, I probably wasnt specific enough. I know how to create a crosstab query, but I dont know how to use the actual fieldnames in a table as my rowsource or columnsource for the query, as opposed to just making each row a grouping of identical values from ONE column.

Essentially what I want to end up doing is just a select query with totals, but unfortunately, there is not an aggregate function built into sql to total using the function I want, which happens to be the 90th percentile.

Hopefully this makes more sense.

 

[Klopper]

why not put the 90th percentile caculation in a select query then create a second query (based on the first select) with the totals?