Manipulating Rows In Access query

[cloh]

I have a pre-written Access query and one of the resulting columns is listed in this format:

A
B
C
A
B
C
A
B

How can I modify my query to show the results in that colums in this format:


A B C
A B C
A B

Please let me know if this is too abstract, but I just need some idea of how to change the sorting or crosstab queries. Thanks in advance!

[puppydogbuddy]

I have a pre-written Access query and one of the resulting columns is listed in this format:

A
B
C
A
B
C
A
B

How can I modify my query to show the results in that colums in this format:


A B C
A B C
A B

Please let me know if this is too abstract, but I just need some idea of how to change the sorting or crosstab queries. Thanks in advance!

You can use your saved query as the data source for a crosstab query. The easiest way to generate a crosstab query is to go to the query object window in the Access DB Window, click "New", and select the crosstab query wizard.

In response to the wizard prompts, enter the following:

Data Source: Your saved query
Column Header: the column with the abc's in the example you gave.
Value Column: the column containing the values that you want to output.
Row Header: All the remaining columns.

Run your crosstab,

[cloh]

I've tried using the crosstab query.. but it takes a really long time to run and more often than not I get an error message that says something like "snapshot is too old".

I know the crosstab query should work in theory because I've seen other queries in a similar format... does anyone have any idea on how to speed the query up? I've looked online, but other than telling me to specify the column headings (which I have done) there doesn't seem to be much else I can do.

[puppydogbuddy]

I've tried using the crosstab query.. but it takes a really long time to run and more often than not I get an error message that says something like "snapshot is too old".

I know the crosstab query should work in theory because I've seen other queries in a similar format... does anyone have any idea on how to speed the query up? I've looked online, but other than telling me to specify the column headings (which I have done) there doesn't seem to be much else I can do.

cloh,
The snapshot too old error appears to be an error generated from the Oracle compiler. Are you running an Oracle back end server with Access front ends? If so why didn't you disclose this information? you need to seek help in an Oracle forum to address the snapshot too old error before addressing anything else.