Run-time error 3061 - Too few parameters. Expected 1 (1 Viewer)

R

ria.arora

Registered User.
Local time
Today, 10:58
Joined
Jan 25, 2012
Messages
109
Dear All,

I'm having wiered issue with one of my SQL.

Below SQL I'm executing from VBA, which is throwing error "Run-time error 3061 - Too few parameters. Expected 1"

Code: 
SELECT tbl_Bankers_Mapping.[GMIS Revenue Producer], SUM([Qtr Annuity Income]) - SUM(NZ([Qtr Annuity Oneoff],0))/3 AS [QtrAnnuity] FROM tbl_Consol_Monthly_Revenue_Split AS CMR INNER JOIN tbl_Bankers_Mapping ON CMR.[Private Banker] = tbl_Bankers_Mapping.[GMIS Revenue Producer] WHERE [YearMonth] = '201209' AND [Region 2]= 'South Asia' AND tbl_Bankers_Mapping.[Exclude] IN (False) AND CMR.[Private Banker] LIKE "*"  GROUP BY tbl_Bankers_Mapping.[GMIS Revenue Producer] ,[Region 2] ORDER BY [Region 2], tbl_Bankers_Mapping.[GMIS Revenue Producer]

If I run same SQL in Backend Database (Access 2007) then it runs without any error.

If I takeout - SUM(NZ([Qtr Annuity Oneoff],0)) from above query then it works fine. Can someone tell me what's wrong I'm doing over here.

Regards
 
pr2-eugin

pr2-eugin

Super Moderator
Local time
Today, 03:58
Joined
Nov 30, 2011
Messages
8,494
If you put this query inside a Normal Access Query window are you able to get the desired result? Try a Debug.Print before you execute the Query that will show how it is actually understood by the DB.. So you will be able to see something there..
 
R

ria.arora

Registered User.
Local time
Today, 10:58
Joined
Jan 25, 2012
Messages
109
Hi Paul

Yes I'm able to run the query from Normal Access Query window and got correct result as well.
 
pr2-eugin

pr2-eugin

Super Moderator
Local time
Today, 03:58
Joined
Nov 30, 2011
Messages
8,494
Try switching the Views as the problem might occur when you are missing parentheses.. Also what method are you using to execute the SQL??
 
R

ria.arora

Registered User.
Local time
Today, 10:58
Joined
Jan 25, 2012
Messages
109
using below syntex

Set rsTmp = gsPnPDatabase.OpenRecordset(strSelectSQL)
 
P

pyrodie18

New member
Local time
Yesterday, 20:58
Joined
Mar 3, 2011
Messages
5
Can you post a copy of the statement that sets strSelectSQL
 
R

ria.arora

Registered User.
Local time
Today, 10:58
Joined
Jan 25, 2012
Messages
109
That's the one which I posted in my first post

Code: 
SELECT tbl_Bankers_Mapping.[GMIS Revenue Producer], SUM([Qtr Annuity Income]) - SUM(NZ([Qtr Annuity Oneoff],0))/3 AS [QtrAnnuity] FROM tbl_Consol_Monthly_Revenue_Split AS CMR INNER JOIN tbl_Bankers_Mapping ON CMR.[Private Banker] = tbl_Bankers_Mapping.[GMIS Revenue Producer] WHERE [YearMonth] = '201209' AND [Region 2]= 'South Asia' AND tbl_Bankers_Mapping.[Exclude] IN (False) AND CMR.[Private Banker] LIKE "*"  GROUP BY tbl_Bankers_Mapping.[GMIS Revenue Producer] ,[Region 2] ORDER BY [Region 2], tbl_Bankers_Mapping.[GMIS Revenue Producer]
 
You must log in or register to reply here.

Similar threads

oxicottin
Solved Run-time error '3061'. Too few parameters. Expected 1
Replies
7
Views
794
theDBguy
theDBguy
L
Error 3061 - Too Few Parameters - Expected 1
Replies
7
Views
618
cheekybuddha
cheekybuddha
N
Solved Run-time error '3061'. Too few parameters. Expected 1
Replies
3
Views
664
silentwolf
S
I
Solved Run time error 3061, too few parameter expected 4., If query has filter based on form control values
Replies
5
Views
738
Ihk
I
J
Solved MS Access SQL too few parameters 3061 "2"
Replies
12
Views
1,029
SHANEMAC51
SHANEMAC51

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom