SQL error

Results 1 to 2 of 2

Thread: SQL error

  1. #1
    Join Date
    Dec 1969

    Default SQL error

    this code isn&#039t workin&#039. can anyone show me the correct way...?<BR><BR>SQLSTATS="SELECT Player, AVG, R, HR, RBI, SB FROM [FinalStats]"<BR>SQLSTATS=SQLSTATS & "WHERE TeamID=" & TeamID<BR>SQLSTATS=SQLSTATS & "ORDER BY AVG;"<BR><BR>this is the error messege:<BR>Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator) in query expression &#039TeamID=TeamIDORDER BY AVG&#039. <BR><BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL error

    insert a space before " order by avg;"

Posting Permissions

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