Database - Viewing Overall Ranking Error

Print Page | Close Window

Viewing Overall Ranking Error

Printed From: Nasgaweb
Category: Nasgaweb Forums
Forum Name: Database
Forum Discription: This forum is for discussion about the NASGA on-line database.
URL: http://www.nasgaweb.com/forum/forum_posts.asp?TID=8559
Printed Date: 3/26/26 at 3:41pm
Software Version: Web Wiz Forums 10.11 - http://www.webwizforums.com

Topic: Viewing Overall Ranking Error

Posted By: buckcali
Subject: Viewing Overall Ranking Error
Date Posted: 2/28/09 at 6:28pm

FYI

Microsoft JET Database Engine error '80040e14'

Wrong number of arguments used with function in query expression 'MAX(IIF(Class.Brstonerank<>0,IIF(Results.Brstonepts Is Null,0,Results.Brstonepts),0)) + MAX(IIF(Class.Opstonerank<>0,IIF(Results.Opstonepts Is Null,0,Results.Opstonepts),0)) + MAX(IIF(Class.Hwgtrank<>0,IIF(Results.Hwgtpts Is Null,0,Results.Hwgtpts),0)) + '.

/dbase/rank_overall6.asp, line 277

-------------
Buck

http://boostinternetmarketing.com" rel="nofollow - Boost Internet Marketing
http://ljtherapy.com/" rel="nofollow - LJ Therapy