If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report Requiring Unsolicited Parameter
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? |
#2
|
|||
|
|||
Report Requiring Unsolicited Parameter
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#? -- Build a little, test a little. "k_hughes1" wrote: 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? |
#3
|
|||
|
|||
Report Requiring Unsolicited Parameter
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. KARL DEWEY wrote: 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#? 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? |
#4
|
|||
|
|||
Report Requiring Unsolicited Parameter
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. k_hughes1 wrote: 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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200908/1 |
#5
|
|||
|
|||
Report Requiring Unsolicited Parameter
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 k_hughes1 via AccessMonster.com wrote: 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. k_hughes1 wrote: 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? |
#6
|
|||
|
|||
Report Requiring Unsolicited Parameter
Tried this and there isn't anything to see in the dialog box except to add
grouping or sorting. John Spencer wrote: 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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200908/1 |
#7
|
|||
|
|||
Report Requiring Unsolicited Parameter
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 "k_hughes1 via AccessMonster.com" u53804@uwe wrote in message news:9a2766f50699a@uwe... Tried this and there isn't anything to see in the dialog box except to add grouping or sorting. John Spencer wrote: 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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200908/1 |
#8
|
|||
|
|||
Report Requiring Unsolicited Parameter
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 Larry Linson wrote: 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] the ID and phone# but not the grade. Anyone have any ideas about this? -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|