10-18-15, 02:01 #1Registered User
- Join Date
- Oct 2015
Unanswered: Report 'Enter Parameter Value' Error
I'm facing this problem when creating a report using the report wizard. I get 'Enter Parameter Value' - SectionID & ", " & CourseID when trying to enter any view other than design view. Leaving the input blank results in an incorrect report.
My SQL is as follows:
SELECT [Section_Query].SectionID, [Section_Query].DayOfWeek, [Section_Query].Location, [Section_Query].StartTime, [Section_Query].EndTime, [Section_Query].CourseID, [Registration].[StudentID] FROM Section_Query INNER JOIN Registration ON ([Section_Query].CourseID=Registration.CourseID) AND ([Section_Query].SectionID=Registration.SectionID);
Section_Query yields no errors, and neither does my Registration table.
10-18-15, 03:34 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
The reason you are getting the message is because the SQL engine cannot find a column of that name so it interprets that text as a prompt for user input.
So check the columns exist
Check for typos / spelling mistakes
Check the syntax for the join. It could be the bracketing, Access / JET SQL is a bit quirky with the JOIN syntaxI'd rather be riding on the Tiger 800 or the Norton