pivot?

[clive]

I have this problem, this query:

Name day Turn
Alberto 1 Morning
Alberto 2 Afternoon
Alberto 3 Evening


it has to become this way:

Name 1 2 3
Alberto Morning Afternoon Evening

Perhaps pivot with strings rather than values (in access or in visual
basic)? Help me!
(I'm italian, excuse me for my english)

Marco

[Tom van Stiphout]

Re: pivot?

On Mon, 15 Nov 2004 14:05:21 +0100, "clive" <clive_03@yahoo .it> wrote:

Check the help file for Crosstab queries
-Tom.

[color=blue]
>I have this problem, this query:
>
>Name day Turn
>Alberto 1 Morning
>Alberto 2 Afternoon
>Alberto 3 Evening
>
>
>it has to become this way:
>
>Name 1 2 3
>Alberto Morning Afternoon Evening
>
>Perhaps pivot with strings rather than values (in access or in visual
>basic)? Help me!
>(I'm italian, excuse me for my english)
>
>Marco
>[/color]