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!

Brain Fart Question....

Status
Not open for further replies.
PogoWolf

PogoWolf

Programmer
Mar 2, 2001
351
US
Hey all!

I've had a brain fart..

with an Access/SQL Statment:
"SELECT Count(*) FROM Users;"

How can I display the return, using ADO and the RecordSet
Object?
******
Darkness... Bleakness...
and Plastic forks...
--The PogoWolf
 
Sort by date Sort by votes

I'm not sure I undersand but is this what you are looking for?

SELECT Count(*) AS RowCnt FROM Users Terry

X-) "I don't have a solution, but I admire your problem."
 
Upvote 0 Downvote
SO.. to display the return on the screen.. I would need to write something like:

Response.Write RowCnt

Correct? =)
******
Darkness... Bleakness...
and Plastic forks...
--The PogoWolf
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

teach314
  • Locked
  • Question
GROUP BY question 1
Replies
2
Views
139
teach314
teach314
Matt K
  • Locked
  • Question
Access left join on multiple criteria question
Replies
0
Views
88
Matt K
Matt K
teach314
  • Locked
  • Question
a permutation question 1
Replies
1
Views
99
ByteMyzer
ByteMyzer
teach314
  • Locked
  • Question
a SELECT TOP question 1
Replies
9
Views
149
teach314
teach314
pastorandy
  • Locked
  • Question
Church DB Question regarding Hymn Check query 2
Replies
17
Views
211
pastorandy
pastorandy

Part and Inventory Search

Sponsor

Back
Top