using COUNT

Results 1 to 2 of 2

Thread: using COUNT

  1. #1
    Join Date
    Dec 1969

    Default using COUNT

    Trying to display the total count from a query using the following:<BR>SELECT count(*) FROM xxxxxx WHERE xxx=&#039 & xxxx & "&#039". <BR><BR><BR>Just need to know how to display the results of the query. Thank you. Chuck

  2. #2
    Join Date
    Dec 1969

    Default RE: using COUNT

    Hi,<BR><BR>Do a search in the previouly posted messages for the recordset count function. It doesn&#039t work how you immediately think it might, but it does if you get the write script :-) Basically, you do your SQL query as normal, then count returns the number of record sets you have requested.<BR><BR>Hope this helps.<BR><BR>DC

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts