 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / April 2006crosstab query
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. > is there a way or version of access that you can select more then 3 fields > for the crosstab query? > > Thanks 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. > is there a way or version of access that you can select more then 3 fields > for the crosstab query? > > Thanks 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 > In a crosstab query you can select many columns. > Multiple ROW HEADING fields [quoted text clipped - 16 lines] > > > > Thanks Are you sure you want a Crosstab query and not a totals query? > thanks, yes basically what i have or want is > [quoted text clipped - 31 lines] >> > >> > Thanks 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 > Are you sure you want a Crosstab query and not a totals query? > [quoted text clipped - 33 lines] > >> > > >> > Thanks 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]; > 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 [quoted text clipped - 40 lines] > > >> > > > >> > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.