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
|
|||
|
|||
Crosstab query - I need aditional information
Dear all in a follow up to another query I have run a crosstab query which
has given me the seperation of information I needed however as always I need more! Because I am exporting data from another d/b in access there is a certain number of fields I need to have added, essentially I have run the crosstab query it looks great but I now need to add additional note fields which cannot be selected through the crosstab wizard. I tried adding them on at the end in design view but it just ignores them. Any help would be gratefully appreciated. thanks you Michael |
#2
|
|||
|
|||
Crosstab query - I need aditional information
WHERE is this other data? Is it in the same table (or one of the tables) as
the table(s) used for the crosstab query? If so, add the field to the query, Change Group By to FIRST Select Row Heading as the crosstab value. John Spencer Access MVP 2002-2005, 2007-2008 The Hilltop Institute University of Maryland Baltimore County Michael wrote: Dear all in a follow up to another query I have run a crosstab query which has given me the seperation of information I needed however as always I need more! Because I am exporting data from another d/b in access there is a certain number of fields I need to have added, essentially I have run the crosstab query it looks great but I now need to add additional note fields which cannot be selected through the crosstab wizard. I tried adding them on at the end in design view but it just ignores them. Any help would be gratefully appreciated. thanks you Michael |
Thread Tools | |
Display Modes | |
|
|