Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

problem with COUNT

Status
Not open for further replies.
LimonaM

LimonaM

Programmer
Oct 27, 2004
50
SI
I have some entrys in form.

Example:
detail
------------------
aaaaaaaaaaaaaaaaaa
bbbbbbbbbbbbbbbbbb


I want to look it like:
counter detail
-----------------------
1 aaaaaaaaaaaaa
2 bbbbbbbbbbbbb

How can i do that?

Help please.

 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
626
carp
carp
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
679
SkipVought
S
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
754
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Change format name with comma 1
Replies
3
Views
170
TheLazyPig
TheLazyPig
kernal
  • Locked
  • Question
If Day of the Week='Y' (i.e. Mon='Y') and between a Start Date and End Date then Count #of Days 1
Replies
1
Views
147
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top