RE: Pivot Table ??

[allyne]

Hi Everyone,

I have a query where the outcome looks like this.

Date Person Count
20080101 PersonA 1
20080101 PersonB 3
20080101 PersonC 1
20080107 PersonA 4
20080107 PersonB 5

What I need to outcome to look like is:

Date PersonA PersonB PersonC
20080101 1 3 1
20080107 4 5

I believe this is called a pivot query but have never done this before and can't get this to work. Any help would be much appreciated.

Thanks!

 

[RiverGuy]

Look at the FAQs button for this forum. There are some entries for dealing with these types of queries.

 

[chamilz]

this might help you.

thread183-1459723