Results 1 to 2 of 2

Thread: IsNull

  1. #1
    Adam Fortney Guest

    IsNull

    I can get the following statement to work in SQL Server, but cannot get it to work on Access, please help

    select isnull(stdev(myvalue2),0) as mystdev from tempstdev where myvalue2>0 and sessionvalue = '25768'

  2. #2
    Chris Thibodeaux Guest

    IsNull (reply)


    Is STDev a recognized function in Access?

    ------------
    Adam Fortney at 8/2/01 3:00:48 PM

    I can get the following statement to work in SQL Server, but cannot get it to work on Access, please help

    select isnull(stdev(myvalue2),0) as mystdev from tempstdev where myvalue2>0 and sessionvalue = '25768'

Posting Permissions

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