asp.net/access avg() sql error... help please

Discussion in 'ASP .Net' started by Steven, Nov 5, 2003.

  1. Steven

    Steven Guest

    I am trying to get an average from an Access table. Has
    anyone seen this SQL error from Access? Thank you in
    advance.

    ERROR: Decimal byte array constructor requires an array
    of length four containing valid decimal bytes.

    This is my query: SELECT AVG(grade) FROM tblEvalGrades
    WHERE SSN='123456789'
     
    Steven, Nov 5, 2003
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Steven

    sql AVG() function problem.

    Steven, Oct 15, 2003, in forum: ASP .Net
    Replies:
    0
    Views:
    618
    Steven
    Oct 15, 2003
  2. KK
    Replies:
    2
    Views:
    1,070
    Big Brian
    Oct 14, 2003
  3. Aaron
    Replies:
    6
    Views:
    1,583
  4. Bill Cunningham

    avg

    Bill Cunningham, Sep 5, 2009, in forum: C Programming
    Replies:
    36
    Views:
    1,475
    Nick Keighley
    Sep 8, 2009
  5. Bill Cunningham

    avg error

    Bill Cunningham, Oct 8, 2009, in forum: C Programming
    Replies:
    30
    Views:
    1,306
    Phil Carmody
    Oct 11, 2009
  6. cooldv
    Replies:
    3
    Views:
    552
    WIlliam Morris
    Oct 6, 2003
  7. David
    Replies:
    4
    Views:
    336
    Bob Barrows [MVP]
    Sep 28, 2006
  8. Matt
    Replies:
    1
    Views:
    178
    Mike Brind
    Jun 1, 2007
Loading...