Too Few Paramater Expecetd 1 (1 Viewer)

J

jj1

New member
Local time
Today, 14:14
Joined
Jan 28, 2015
Messages
3
I created a crosstab query and added a parameter. When I am trying to run the report it keep giving me error "Too Few Paramater Expecetd 1".

Query runs fine. The problem arises only while running the report.

The SQL for the query is
PARAMETERS [Forms]![EmployeePillarTeamSkillsSelect]![DeptName] Value;
TRANSFORM Count(TrainingCourseListSummary.TrainingCourseList2.[2Criteria]) AS CountOfTrainingCourseList2_2Criteria
SELECT TrainingCourseListSummary.TrainingCourseList2.Hours, TrainingCourseListSummary.TrainingCourseList2.Lead, TrainingCourseListSummary.TrainingCourseList2.Area, TrainingCourseListSummary.TrainingCourseList2.TrainingCourseList.DeptName, TrainingCourseListSummary.TrainingCourseList2.LastName, First(TrainingCourseListSummary.TrainingCourseList2.FirstName) AS FirstOfTrainingCourseList2_FirstName
FROM TrainingCourseListSummary
WHERE (((TrainingCourseListSummary.TrainingCourseList2.TrainingCourseList.DeptName)=[Forms]![EmployeePillarTeamSkillsSelect]![DeptName])) OR ((([Forms]![EmployeePillarTeamSkillsSelect]![DeptName]) Is Null))
GROUP BY TrainingCourseListSummary.TrainingCourseList2.Hours, TrainingCourseListSummary.TrainingCourseList2.Lead, TrainingCourseListSummary.TrainingCourseList2.Area, TrainingCourseListSummary.TrainingCourseList2.TrainingCourseList.DeptName, TrainingCourseListSummary.TrainingCourseList2.LastName
PIVOT TrainingCourseListSummary.TrainingCourseList2.[2Criteria];
Click to expand...

Please help me find out my mistake.
 
Mile-O

Mile-O

Back once again...
Local time
Today, 22:14
Joined
Dec 10, 2002
Messages
11,316
Are you using VBA in your report to build this SQL? Say, using the QueryDefs object and/or a Recordset object?
 
Minty

Minty

AWF VIP
Local time
Today, 22:14
Joined
Jul 26, 2013
Messages
10,371
You have to define the parameters for a cross tab query if it's called from anywhere other than opening the query directly. Right click in the design view and select parameters then duplicate the [Forms]![EmployeePillarTeamSkillsSelect]![DeptName] and
[Forms]![EmployeePillarTeamSkillsSelect]![DeptName]
references and set their data type correctly.
 
You must log in or register to reply here.

Similar threads

O
Using Cross Tab Query In Report
Replies
3
Views
530
Pat Hartman
P
L
Error 3061 - Too Few Parameters - Expected 1
Replies
7
Views
616
cheekybuddha
cheekybuddha
M
RecordSet vs Recordsource for dynamically binding data
2
Replies
21
Views
752
ebs17
E
N
Can't get query criteria to read a form text field
Replies
9
Views
442
Pat Hartman
P
C
Solved Error 3061 too few parameters
Replies
14
Views
847
theDBguy
theDBguy

Users who are viewing this thread

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