By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,630 Members | 1,427 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,630 IT Pros & Developers. It's quick & easy.

Too Few Parameters Error

P: 1
I've been trying to debug this too few parameters error, any help?

Help is the code

strSQL = "SELECT ((H.A/d.r)*100) AS [Fast Track], ((M.B/d.r)*100) AS Normal, ((L.C/d.r)*100) AS [After the Fact] " & _
"FROM (select (COUNT([Change Type])) as R from CMNonSampling where CMNonSampling.[Business Unit] = ""HCD"") AS d, " & _
"(SELECT COUNT([Change Type]) AS A FROM CMNonSampling WHERE [Change Type]= ""Fast Track"" and CMNonSampling.[Business Unit] = ""HCD"") AS H, " & _
"(SELECT COUNT([Change Type]) AS B FROM CMNonSampling WHERE [Change Type]= ""Normal"" and CMNonSampling.[Business Unit] = ""HCD"") AS M, " & _
"(SELECT COUNT([Change Type]) AS C FROM CMNonSampling WHERE [Change Type]= ""After the Fact"" and CMNonSampling.[Business Unit] = ""HCD"") AS L " & _
"GROUP BY H.a, m.b, l.c, d.r; "

With too few parameters 4 as the error

Nov 29 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.