Parameter Query with 2 many prompts in Report

  • Thread starter Thread starter DSmith
  • Start date Start date
D

DSmith

I have this query below that works fine in query form but when you try to
open up the report that it's attached to, I get 3 prompts. Any help is
greatly appreciated.

SELECT [CLASS STUDENTS].ClassCode, [CLASS CITIES].LocationCity, [CLASS
COURSES].CourseID, [CLASS COURSES].CourseName, [CLASS
STUDENTS].CourseStatus, TECHS.TechID, TECHS.LastName, TECHS.FirstName,
TECHS.MiddleName, TECHS.Address, TECHS.Address2, TECHS.City, TECHS.State,
TECHS.Zipcode, DOCTORS.ClinicName
FROM ((([CLASS STUDENTS] INNER JOIN TECHS ON [CLASS STUDENTS].TechID =
TECHS.TechID) INNER JOIN [CLASS CITIES] ON [CLASS STUDENTS].ClassCode =
[CLASS CITIES].ClassCode) INNER JOIN [CLASS COURSES] ON [CLASS
STUDENTS].CourseID = [CLASS COURSES].CourseID) LEFT JOIN DOCTORS ON [CLASS
STUDENTS].ClinicID = DOCTORS.ClinicID
WHERE ((([CLASS STUDENTS].ClassCode) Like [Enter the first character to
search by: ] & "*") AND (([CLASS STUDENTS].CourseStatus)="RT"))
ORDER BY TECHS.LastName, TECHS.FirstName;
 
I have this query below that works fine in query form but when you try to
open up the report that it's attached to, I get 3 prompts. Any help is
greatly appreciated.

SELECT [CLASS STUDENTS].ClassCode, [CLASS CITIES].LocationCity, [CLASS
COURSES].CourseID, [CLASS COURSES].CourseName, [CLASS
STUDENTS].CourseStatus, TECHS.TechID, TECHS.LastName, TECHS.FirstName,
TECHS.MiddleName, TECHS.Address, TECHS.Address2, TECHS.City, TECHS.State,
TECHS.Zipcode, DOCTORS.ClinicName
FROM ((([CLASS STUDENTS] INNER JOIN TECHS ON [CLASS STUDENTS].TechID =
TECHS.TechID) INNER JOIN [CLASS CITIES] ON [CLASS STUDENTS].ClassCode =
[CLASS CITIES].ClassCode) INNER JOIN [CLASS COURSES] ON [CLASS
STUDENTS].CourseID = [CLASS COURSES].CourseID) LEFT JOIN DOCTORS ON [CLASS
STUDENTS].ClinicID = DOCTORS.ClinicID
WHERE ((([CLASS STUDENTS].ClassCode) Like [Enter the first character to
search by: ] & "*") AND (([CLASS STUDENTS].CourseStatus)="RT"))
ORDER BY TECHS.LastName, TECHS.FirstName;
Click to expand...

You query, as written calls for just one prompt.
If the query works ok, then the additional prompts are coming from the
report.
Usually, this is a field used in the report that is not included in
the report's record source,
OR (quite often), a Field in the Sorting and Grouping dialog that is
no longer a part of the report and someone forgot to delete it,
Or.. most common, a mis-spelled control name somewhere in the report.
Or.. You wrote "SomeValue" when you should have written ="SomeValue"
as the control source of a control.
The extra parameter boxes will say "Enter Parameter Value" SomeValue.
Search for that SomeValue in the report.
 
Back
Top