Report 'Enter Parameter Value' Error

[ndehhh]

Hi, sorry for the constant spam of help threads.



I created a report using the report wizard on Access to include my section query (Containing Section ID, Course ID, Start Time, End Time, Day of Week, & Location) and Student ID registered under course & section IDs (From my table 'Registration'). However, I keep getting the message box 'Enter Parameter Value', 'Section ID & ", " & Course ID'.

Anyone know what could be the problem and solution? I've Googled it and double checked for my data types as well as the presence of any sorting but to no avail.

[CJ_London]

because you are using spaces in your field names, you need to surround them with square brackets - an error easily avoided if you didn't use spaces

[ndehhh]

Hi, I've removed all spaces from field names, and I get the same error. Only this time without spaces in between Section & ID and Course & ID

i.e. 'SectionID &", "& CourseID​'

[CJ_London]

ok - what is the full sql?

[ndehhh]

Hi, Here's the recordsource of my report:

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);

[ndehhh]

[Removed]

Also, here's my database!

[CJ_London]

Thanks - but I don't see the bit you have a problem with

'SectionID &", "& CourseID​'

are you building this in vba? or perhaps the error is in your query called Section_Query?