Newbie's Question on Splitting one Column into many

[ranjinitr]

Hi,

I wonder if this is an oft-repeated query. But, I'd really appreciate your help.

I have a table that looks like this:

Site-Code--Site-Name--Link-Status--Status Date
AAA--------XXXXX------0------------01/14/2005
AAA--------XXXXX------1------------01/15/2005
AAA--------XXXXX------1------------01/16/2005
BBB--------YYYYY------1------------01/14/2005
BBB--------YYYYY------0------------01/15/2005
BBB--------YYYYY------1------------01/16/2005
CCC--------ZZZZZ------1------------01/14/2005
CCC--------ZZZZZ------1------------01/15/2005
CCC--------ZZZZZ------0------------01/16/2005

Using a Query, can I get something like this ?
Site-Code--Site-Name--01-14-2005--01-15-2005--01-16-2005--TOTAL
AAA--------XXXXX------0------------1------------1-------------2
BBB--------YYYYY------1------------0------------1-------------2
CCC--------ZZZZZ------1------------1------------0-------------2

TOTAL------------------2------------2------------2

I'd really appreciate a response. Thank you for your time.

 

[GabrielR]

Yes you can get a query that portraits the information that way, use the Crosstab query wizard and play with the query a little, there is available help here and in access about crosstab queries, after some time you will get the hang of it.