Crosstab query?

[Ravenmike via AccessMonster.com]

I am attempting to display the results of a query in a datasheet view to my
user, but in a "spreadsheet" method...The view I am looking for is exactly
like a crosstab query, but without the values of the crosstab being
calculated...I only want the simple data to be displayed. I have
experimented with the PivotTable, but found it too unwieldy and problematic.

I am looking to have the following headers:
Rows: "Fueler"
Colums: "# of Gallons"
Values "Price per gallon"

This method will allow me to check at a glance who has the best price based
on a variable number of gallons when fuelers charge different prices for
different quanities.

So...in a nut shell...is there a way to display simple non calcuated values
in a crosstab query, or another way to display the info in a similar manner?

Thanks in advance.
Mike.

 

[Guest]

There probably is but what does your data look like now?

Post a sample of your data.

 

[David F Cox]

use the First option?

 

[harry.pramana]

Is it possible to use "Avg" for The Value in your purpose ?