Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  add row number per "group" for crosstab

Author  Topic  yvanvw Starting Member 1 Post Posted - 2005-08-24 : 08:14:11 Hi all, I searched around for a while but I could not find the answer to my question: I would like to add a row number to a query, but the number should restart from 0 when the "group" changes, in order to have column name for crosstab. Here is an example: My table stores servers and their connections to power outlets: server outlet ------------------------ serverA outlet1 serverA outlet2 serverB outlet3 serverB outlet4 serverC outlet1 serverC outlet3 serverC outlet5 What I would like my query to return: server outlet powersupply number ---------------------------------------------- serverA outlet1 1 serverA outlet2 2 serverB outlet3 1 serverB outlet4 2 serverC outlet1 1 serverC outlet3 2 serverC outlet5 3 Thanks to the powersupply number, I will be able to have such a crosstab: server PowSup1 PowSup2 PowSup3 ------------------------------------------ serverA outlet1 outlet2 serverB outlet3 outlet4 serverC outlet1 outlet3 outlet5 Thanks in advance for your help. Yvan