multiple records into 1 row

[Guest]

hi i have my data organized in a table like this,

pID itemType

and i might have records like this in the table

11 Chart
11 Picture
11 Text
12 Chart
12 Text

What kind of query do i need to implement to get the data in the following
form:

pID Chart Picture Text

and the previous data would transform into

11 yes yes yes
12 yes no yes

Thanks

 

[Jeff Boyce]

Take a look at "crosstab queries"

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Thanks, yes crosstab queries somewhat helped. the only problem is that now
the data comes out like this

11 yes
11 yes
11 yes
12 yes
12 no
12 yes

how can i aggragate the data so it is in one record?

 

[Jeff Boyce]

Please post the SQL statement of your query. You wouldn't normally see
three rows of "11", three rows of "12", etc., unless there were other
(non-visible) fields being used.

Regards

Jeff Boyce
Microsoft Office/Access MVP