Changing field value into indicator columns with 0s and 1s 1

[VBAguy22]

Hi,
How would I change table field values into indicator columns?
Say I have a table containing people and their pets:
(If a person has more than one pet, his name will appear twice with a coresponding pet name)

NAME PET

Anna Cat
Dan Cat
Dan Fish
Mike Dog
Mike Cat
Mike Fish


I want it to become:

Name Cat Fish Dog
Anna 1 0 0
Dan 1 1 0
Mike 1 1 1


Thnx!

 

[PHV]

Have you tried to follow the CrossTab query wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886