MS Access Query Help

Hi,

Hoping someone can help me find a solution to the following problem I
have.

I have a query that currently pulls the following information from
Table A

Project Name Milestone Date
-------------------------\--------------------------
Project A Date 1
Project A Date 2
Project A Date 3
Project B Date 1
Project B Date 2
Project C Date 1
Project C Date 2
Project C Date 3
Project C Date 4

But What I really want to pull is the following:

Project Name Date1 Date2 Date3
Date4
-------------------------\----------------\----------------- -
\--------------------\-------------
Project A Date 1 Date 2 Date 3
Project A Date 1 Date 2
Project A Date 1 Date 2 Date 3
Date4

How do I go about doing something like that?

Re: MS Access Query Help

Jordan M. wrote:
> Hi,
>
> Hoping someone can help me find a solution to the following problem I
> have.
>
> I have a query that currently pulls the following information from
> Table A
>
> Project Name Milestone Date
> -------------------------\--------------------------
> Project A Date 1
> Project A Date 2
> Project A Date 3
> Project B Date 1
> Project B Date 2
> Project C Date 1
> Project C Date 2
> Project C Date 3
> Project C Date 4
>
> But What I really want to pull is the following:
>
> Project Name Date1 Date2 Date3
> Date4
> -------------------------\----------------\----------------- -
> \--------------------\-------------
> Project A Date 1 Date 2 Date 3
> Project A Date 1 Date 2
> Project A Date 1 Date 2 Date 3
> Date4
>
> How do I go about doing something like that?
>
If you click Queries/New you might find CrossTab or Pivot tables.