Results 1 to 2 of 2

Thread: Average in a continous form

  1. Feb 26th, 2007, 11:49 PM #1
    Prav
    Prav is offline

    Thread Starter
    Addicted Member
    Join Date
    Nov 2005
    Posts
    208

    Exclamation Average in a continous form

    Hi i have a textbox on continous form showing the percentage. I used =Avg([txtAvgPer]) to display the average in another textbox, however its showing '#Name'. Any help will be much appricated. Thank you.
    Reply With Quote Reply With Quote
  2. Feb 27th, 2007, 07:13 AM #2
    salvelinus
    salvelinus is offline
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Re: Average in a continous form

    I don't think you can AVG() a text value. You also need at least 2 numbers to get an average. Don't know if the continous form affects it.
    Tengo mas preguntas que contestas
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width