Crosstab Query problem

  • Thread starter Thread starter Blair
  • Start date Start date
B

Blair

I tried to make a report off a crosstab query by using the wizard. When I
choose the query and click ok, and have the window to pick my fields, there
are no fields showing. I have tried making a new query, another query and
anything else I can think of, nothing works.
can anyone help
Thanks Blair
 
Yes If I choose the query the crosstab is based on the fields show.
I have already made 1 report off this crosstab and it went tikity boo, I
have never used wizards before so I didn't really know what I was doing and
have never made a crosstab before which is why I used the wizard. Now I
wanted to do it again to play with the options to see what the changes would
do to the layout of my report and now the fields in the crosstab won't show.
They show in the query if you open in design view and the query works. I
don't know how to make a crosstab without the wizard.There is a total row in
the report and query and I can't find it in design view of the report or
query, can you even modify the total row?
Thanks for any help
Blair
 
"went tikity boo" must be Canadian? I'm not sure if any of your wizards
work. If not, you can search google groups on Access Wizards don't work.

Crosstabs aren't too difficult once you get the hang of the terms. If you
provided some field names and desired final display, I'm sure someone could
help you.
 
You Goter Pontiac, 100% Nova Scotian Hick.
You guys are great, I'll try some things and we'll geter figered out
Thanks Blair
 
This is the sql of the crosstab query I want. Shed is the column heading,
WhelpingDate is the row heading. The very first row is the count total for
each shed and there is a grand total at the end of the row. There is no sum
total of the shed column as the nests increase. The top total decreases as
the nest increase but there is no nest total at the bottom of the column.
The total at the end of the row is the sum of the day of all sheds. I would
like to have a grand total that the total of row 1 is added to the total of
row 2 for a row 2 grand total. Then row 3 total added to grand total of row
2 for row 3 grand total, etc. etc. I would then like percentages calculated
on these numbers and totals.
Any suggestion would be appreciated
Thanks Blair
 
For got the sql sorry

TRANSFORM Count(QDailyWheplingReport.[NEST #]) AS [The Value]
SELECT QDailyWheplingReport.[WHELPING DATE],
Count(QDailyWheplingReport.[NEST #]) AS [Total Of NEST #]
FROM QDailyWheplingReport
GROUP BY QDailyWheplingReport.[WHELPING DATE]
PIVOT QDailyWheplingReport.[SHED #];

Thanks Blair
 
I really don't understand your base data or what you want. To get running
sums or group sums of columns, build a report.
--
Duane Hookom
MS Access MVP

Blair said:
For got the sql sorry

TRANSFORM Count(QDailyWheplingReport.[NEST #]) AS [The Value]
SELECT QDailyWheplingReport.[WHELPING DATE],
Count(QDailyWheplingReport.[NEST #]) AS [Total Of NEST #]
FROM QDailyWheplingReport
GROUP BY QDailyWheplingReport.[WHELPING DATE]
PIVOT QDailyWheplingReport.[SHED #];

Thanks Blair
Click to expand...
 
Back
Top