-=-=-=-HELP!!!!! SQL Master Needed!!!!!-=-=-=-=-

Results 1 to 2 of 2

Thread: -=-=-=-HELP!!!!! SQL Master Needed!!!!!-=-=-=-=-

  1. #1
    Aaron Eden Guest

    Default -=-=-=-HELP!!!!! SQL Master Needed!!!!!-=-=-=-=-

    Ok, I think anyone who knows a good ammount about SQL should be able to help out with this one... I am using this with ASP, on an Access database<BR>-------------<BR>Select ((Count(cwUsers.NumReferrals)*2)+Count(cwJobs.Titl e)) As Points,cwJobs.UserID,cwUsers.Id from cwUSers Inner Join cwJobs On cwJobs.UserId=cwUsers.ID order by Points Desc <BR>----------<BR>I am attempting to create a top ten users listing with this by giving the users points based on criteria. When I execute this statement I get the following error message.<BR>----------------------<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression &#039UserID&#039 as part of an aggregate function. <BR>---------------------<BR>Can anyone PLEASE help!!!<BR>

  2. #2
    Mubarak Guest

    Default RE: -=-=-=-HELP!!!!! SQL Master Needed!!!!!-=-=-=-

    Group by Userid.....

Posting Permissions

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