Results 1 to 2 of 2

Thread: formulas

  1. #1
    8575 Guest

    Default formulas

    i have members registering everyday. <BR>What is the query to find out how many new members per day?<BR>What is the query to find out percentage growth per day?<BR>thanks

  2. #2 Guest

    Default RE: formulas

    SELECT COUNT(*) AS &#039COUNT&#039 FROM Table WHERE Condition=Something will return a single row and a single column named Count representing the number of rows matching the results of the SQL statement. You could do math by setting variables to the value of lngVariable1=rstRecordset1("Count") And lngVariable2=rstRecordset2("Count") ... then do math from there.<BR>

Posting Permissions

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