question-please go thro!

Results 1 to 2 of 2

Thread: question-please go thro!

  1. #1
    user Guest

    Default question-please go thro!

    Hi all,<BR> <BR> if I have something like:<BR><BR>Select sum(TotalVisitors) TotVisit,sum(TotalEmails) TotEmails from tblAdvertiser where flduser=&#039"&BuilderId&"&#039" <BR> rsVisitEmail.Open SQLstr, HomeDB, 3, 1 <BR><BR>where TotVisit,TotEmails are the temporary columns.<BR>then, can we use something like rsVisitEmail("TotVisit")<BR>in the recordset to extract the sum of the column.<BR>It does&#039nt work. If this is not the correct method, how would I do it?

  2. #2
    Join Date
    Dec 1969

    Default RE: question-please go thro!

    You need to check you statement in Query Analyser - it&#039s wrong statement, you need to use GROUP BY

Posting Permissions

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