SQL Statement Problem

Results 1 to 3 of 3

Thread: SQL Statement Problem

  1. #1
    Leif Guest

    Default SQL Statement Problem

    Hello - Could someone please point out what is wrong with this SQL statement:<BR><BR>SqlText = "SELECT Count(hrg_PostMark_Date, hrg_Date_Final) As Uncompleted"<BR>SqlText = SqlText & " FROM tblHearings"<BR>SqlText = SqlText & " WHERE (((hrg_PostMark_Date) Is Not Null) AND (hrg_Date_Final) Is Null);"<BR><BR>I receive the error:<BR><BR>Wrong number of arguments used with function in query expression<BR><BR>Thanks<BR><BR>

  2. #2
    James W. Guest

    Default RE: SQL Statement Problem

    the count function works on a single field, so if you need multiple fields do this:<BR>SELECT Count(hrg_PostMark_Date) as thisthing, count(hrg_Date_Final) as thatthing

  3. #3
    Leif Guest

    Default RE: SQL Statement Problem

    Great. Thanks a lot.

Posting Permissions

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