Report Requiring Unsolicited Parameter

[k_hughes1]

I have created a query from 1 table to use for a report. The query includes
two 1 position fields (Room and Session) and a concatonation of names (last,
first, middle). Excluded from the query are the remaining fields of ID (Key),
Grade and Phone#. When I open the report created from the query it requests
the ID and phone# but not the grade. Anyone have any ideas about this?

 

[KARL DEWEY]

Was the report created by the wizard? It might have added those fields.
Are there text boxes for those fields?
Did you use the Documentor to analyze the report for ID and phone#?

 

[k_hughes1]

Yes I did. But how could the fields be aded when they are not included in the
query? The ID field is the table key (autonumber) and the phone# is text
formatted for a US phone number. I have not used the Documentor to analyze
the report but will do so now. I'll get back.

 

[k_hughes1 via AccessMonster.com]

Ran the Documenter on the report (clean) and the query (seems the problem is
here). In the Properties section of the report the 2 fields in question show
up as items for the OrderBy: [Students].[Student_ID] and [Students].[Phone
Number] DESC. I have never seen anything like this; I'm baffled.

Yes I did. But how could the fields be aded when they are not included in the
query? The ID field is the table key (autonumber) and the phone# is text
formatted for a US phone number. I have not used the Documentor to analyze
the report but will do so now. I'll get back.

Was the report created by the wizard? It might have added those fields.
Are there text boxes for those fields?

[quoted text clipped - 4 lines]

 

[John Spencer]

Usually, I find that the problem is in the SORTING and Grouping of the report.

Open the report in design view
Open the sorting and grouping dialog (View: Sorting and Grouping)
If you see the two offenders in the dialog, remove them.
Close the dialog and save the report.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Ran the Documenter on the report (clean) and the query (seems the problem is
here). In the Properties section of the report the 2 fields in question show
up as items for the OrderBy: [Students].[Student_ID] and [Students].[Phone
Number] DESC. I have never seen anything like this; I'm baffled.

Yes I did. But how could the fields be aded when they are not included in the
query? The ID field is the table key (autonumber) and the phone# is text
formatted for a US phone number. I have not used the Documentor to analyze
the report but will do so now. I'll get back.

Was the report created by the wizard? It might have added those fields.
Are there text boxes for those fields?

[quoted text clipped - 4 lines]

Grade and Phone#. When I open the report created from the query it requests
the ID and phone# but not the grade. Anyone have any ideas about this?

 

[k_hughes1 via AccessMonster.com]

Tried this and there isn't anything to see in the dialog box except to add
grouping or sorting.

Usually, I find that the problem is in the SORTING and Grouping of the report.

Open the report in design view
Open the sorting and grouping dialog (View: Sorting and Grouping)
If you see the two offenders in the dialog, remove them.
Close the dialog and save the report.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Ran the Documenter on the report (clean) and the query (seems the problem is
here). In the Properties section of the report the 2 fields in question show

[quoted text clipped - 11 lines]

 

[Larry Linson]

For your information, the ORDER BY of a Query used as Record Source for a
report is meaningless. The only ordering you can count on is that in
Sorting and Grouping. Open the Query in Design View (don't try to get there
starting from the Data tab of Report Properties, just open the Query). Look
in the Sort Line and the Criteria Line of Report Design View. Not knowing
anything more than what you have written, I don't think anyone here could do
more than make some wild guess.

Larry Linson
Microsoft Office Access MVP

Tried this and there isn't anything to see in the dialog box except to add
grouping or sorting.

Usually, I find that the problem is in the SORTING and Grouping of the
report.

Open the report in design view
Open the sorting and grouping dialog (View: Sorting and Grouping)
If you see the two offenders in the dialog, remove them.
Close the dialog and save the report.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Ran the Documenter on the report (clean) and the query (seems the
problem is
here). In the Properties section of the report the 2 fields in question
show

[quoted text clipped - 11 lines]

Grade and Phone#. When I open the report created from the query it
requests
the ID and phone# but not the grade. Anyone have any ideas about
this?

 

[k_hughes1 via AccessMonster.com]

Problem solved. The issue was in the query. Instead using the wizard to build
the query I built it from scratch, so to speak. Thanks to all who responded.
Ken

For your information, the ORDER BY of a Query used as Record Source for a
report is meaningless. The only ordering you can count on is that in
Sorting and Grouping. Open the Query in Design View (don't try to get there
starting from the Data tab of Report Properties, just open the Query). Look
in the Sort Line and the Criteria Line of Report Design View. Not knowing
anything more than what you have written, I don't think anyone here could do
more than make some wild guess.

Larry Linson
Microsoft Office Access MVP

Tried this and there isn't anything to see in the dialog box except to add
grouping or sorting.

[quoted text clipped - 21 lines]