If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
multiple crosstab in report
I have been trying to create a report based on several queries. The first
query is a crosstab that gives me counts by state and color. from that crosstab, I have create and a 2nd and 3rd query which calculates a percentage based on the total count from query 1. Each query works fine by itself and even with 2 queries together. When I add the 3rd query the results are incorrect. I'm thinking the query is taking the first total and calculating from that rather than by each color. I'm trying to obtain these results Species Total Blue Brown Yellow Gray State1 15 7 3 2 3 (calc of local% of color based on # in ea column) (calc of local% of color based on # in ea column) State2 12 5 0 4 3 (calc of local% of color based on # in ea column) (calc of local% of color based on # in ea column) I'm trying to place the final result in a report that looks like the above. I've tried to create an unbound report, changing the source to each separate query but the report keeps giving me an error# or name? message. I've tried subreports, but I want the entire report merged together by state rather than separate reports within each other.So I'm back to figuring out why the query displays incorrect calculations. Any thoughts on what is the best approach to this? |
#2
|
|||
|
|||
multiple crosstab in report
I forgot to add that each group of information is based on a species within
the state (which is calculated by the 1st query) such as VA could have a row with Dog, Cat, Cow and DC could have on Dog and Cow. Then the caluclated columns "Mpower" wrote: I have been trying to create a report based on several queries. The first query is a crosstab that gives me counts by state and color. from that crosstab, I have create and a 2nd and 3rd query which calculates a percentage based on the total count from query 1. Each query works fine by itself and even with 2 queries together. When I add the 3rd query the results are incorrect. I'm thinking the query is taking the first total and calculating from that rather than by each color. I'm trying to obtain these results Species Total Blue Brown Yellow Gray State1 15 7 3 2 3 (calc of local% of color based on # in ea column) (calc of local% of color based on # in ea column) State2 12 5 0 4 3 (calc of local% of color based on # in ea column) (calc of local% of color based on # in ea column) I'm trying to place the final result in a report that looks like the above. I've tried to create an unbound report, changing the source to each separate query but the report keeps giving me an error# or name? message. I've tried subreports, but I want the entire report merged together by state rather than separate reports within each other.So I'm back to figuring out why the query displays incorrect calculations. Any thoughts on what is the best approach to this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to run a report for multiple selections? | Amit | Setting Up & Running Reports | 0 | February 9th, 2005 07:25 PM |
CrossTab Report with parameters | Scott | Setting Up & Running Reports | 3 | January 22nd, 2005 09:41 PM |
Report totals by day of week - from crosstab report | Barbara Waller | Setting Up & Running Reports | 10 | January 9th, 2005 07:02 PM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |