crosstab query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there a way or version of access that you can select more then 3 fields
for the crosstab query?

Thanks
 
Yes. Do you want more rows or more columns?

If you want more rows then just add in the design view grid.

I add columns by using a select query that concatenates fields as input to
the crosstab query.
 
In a crosstab query you can select many columns.
Multiple ROW HEADING fields
One COLUMN HEADING Field
One Value field.

So, what are you trying to achieve. There are various solutions to allow
you to have multiple values show up under the Column heading fields.

Duane Hookom is pretty darn good at this and if you give some details on the
problem you are trying to solve and the tables and fields involved he can
either point you to a solution or help to develop one.

If it is strictly a query problem, post a query that gives you the data you
want - even if it is not in the form you want and perhaps I or someone else
(Tom Ellison, Duane, Michel) can help you write a query to return the data
you want.
 
thanks, yes basically what i have or want is

item code, description, vendor, pack size, cost as fields and columns i want
are total sales dollars, to cost dollars, qty invoiced, and qty on hand.

Currently i can just get 3 fields and one column total, using the wizard.

Thanks a bunch
 
what is a totals query? i basically need about 5 fields and for it to sum
around 3 columns or so. Rignt now it only lets me do 3 fields and one column
sum using the wizard.

Thanks alot
Grant
 
This is a totals query --
SELECT ashaback.[item code], ashaback.description, ashaback.vendor,
ashaback.[pack size], Sum(ashaback.cost) AS SumOfcost, Sum(ashaback.qty) AS
SumOfqty
FROM ashaback
GROUP BY ashaback.[item code], ashaback.description, ashaback.vendor,
ashaback.[pack size];
 
Back
Top