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 |
#11
|
|||
|
|||
Field Prints Different When I change it to heading.
O', and by the way since I took all the look up fields out(and this didn't fix the problem), I figued it was the query in the row source property that populated my combo box it did have the Team ID and the Team Name. I tried to remove the Team ID but the combo box wouldn't work then. Thanks, Kurt "Duane Hookom" wrote: Regarding lookup fields, check this page http://www.mvps.org/access/lookupfields.htm. Is your report now working as expected? -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... Did you use a lookup field in a table? Originally, but after your post I changed that, but it did not change the outcome. Did your original query contain the team name field? Yes it did. I changed that after you post and the error message still appeared. Did you expect a table with the team ID value to automatically include the team name table in the report? Yes I did. Since the wizard produced the Team names in the report when I did not use the the Team name as a header, I figured it would produce the same results when I chose the Team name as a header. I am unclear as to why using the look up field is bad. Are there times when it is good? "Duane Hookom" wrote: Did you use a lookup field in a table? Did your original query contain the team name field? Did you expect a table with the team ID value to automatically include the team name table in the report? If you used a lookup field in a table, again, suggestiondon't/suggestion. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... I Just fixed it . It must have had somthing to do with the original Table that the query was based on that filled the report. The Report Where I didn't have a Team Header had the combo box arrow still with it (of course it doesn't work). The report with the Team Header did not have the combo box arrow. I copied the box with the arrow to the report with the header and it worked. Why the "Wizard" did this I don't understand. "Duane Hookom" wrote: If you place a field in your report that contains the team name text then it will display the team name text. Did you use a lookup field in your table? If so, get rid of it since it seems to be causing you confusion. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... I Tried This and it did'nt work. Does the Same thing. I don't understand...I create a form with this Team field not being a Header and it prints Just fine. I Change that, using the "Wizard" again and it returns a number. "Duane Hookom" wrote: Place the table that actually contains the team name in the report's record source. This will allow you to place the real team name in your report. BTW: most of us recommend against using lookup fields in tables. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... When use the Report Wizard to Create a Report If I don't Create and groupings it Prints the name of the team I want but when I put the team as a header it prints the team number. The Souce of the Fields is a Query. I would like to Print the Team Name as a header not the number. Why does it change? |
#12
|
|||
|
|||
Field Prints Different When I change it to heading.
I'm lost as to what you have and what you need. If you want to display the
team name in your report, your report's record source should include the table with the team name field. Is this what you have? You might need to share the SQL view of your report's record source. You can use combo boxes on forms so that you end up storing the primary key from the lookup table in the related tables. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... O', and by the way since I took all the look up fields out(and this didn't fix the problem), I figued it was the query in the row source property that populated my combo box it did have the Team ID and the Team Name. I tried to remove the Team ID but the combo box wouldn't work then. Thanks, Kurt "Duane Hookom" wrote: Regarding lookup fields, check this page http://www.mvps.org/access/lookupfields.htm. Is your report now working as expected? -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... Did you use a lookup field in a table? Originally, but after your post I changed that, but it did not change the outcome. Did your original query contain the team name field? Yes it did. I changed that after you post and the error message still appeared. Did you expect a table with the team ID value to automatically include the team name table in the report? Yes I did. Since the wizard produced the Team names in the report when I did not use the the Team name as a header, I figured it would produce the same results when I chose the Team name as a header. I am unclear as to why using the look up field is bad. Are there times when it is good? "Duane Hookom" wrote: Did you use a lookup field in a table? Did your original query contain the team name field? Did you expect a table with the team ID value to automatically include the team name table in the report? If you used a lookup field in a table, again, suggestiondon't/suggestion. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... I Just fixed it . It must have had somthing to do with the original Table that the query was based on that filled the report. The Report Where I didn't have a Team Header had the combo box arrow still with it (of course it doesn't work). The report with the Team Header did not have the combo box arrow. I copied the box with the arrow to the report with the header and it worked. Why the "Wizard" did this I don't understand. "Duane Hookom" wrote: If you place a field in your report that contains the team name text then it will display the team name text. Did you use a lookup field in your table? If so, get rid of it since it seems to be causing you confusion. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... I Tried This and it did'nt work. Does the Same thing. I don't understand...I create a form with this Team field not being a Header and it prints Just fine. I Change that, using the "Wizard" again and it returns a number. "Duane Hookom" wrote: Place the table that actually contains the team name in the report's record source. This will allow you to place the real team name in your report. BTW: most of us recommend against using lookup fields in tables. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... When use the Report Wizard to Create a Report If I don't Create and groupings it Prints the name of the team I want but when I put the team as a header it prints the team number. The Souce of the Fields is a Query. I would like to Print the Team Name as a header not the number. Why does it change? |
#13
|
|||
|
|||
Field Prints Different When I change it to heading.
I'm lost as to what you have and what you need. ***Sorry this can be a little difficult to articulate for me. I'll try again. If you want to display the team name in your report, your report's record source should include the table with the team name field. *** I agree, but I get an error message when I try to do so. The error message I reported above. Is this what you have? No, because of the error message I am prevented from doing so. What I am forced to do instead is use the team name from the Query that creates the data for the report. You might need to share the SQL view of your report's record source. ***This I do not understand. Here I'll try again to be clear about what I have and what I am trying to do and what problem arises when I try to do this. Please not that I have no look up fields( these have been removed on you suggestion). I will then Try to be clear about what happens when I try your solution. What I have: a Table that has a field of 'Team names' and a field of 'Team ID' numbers that is the primary key for this table. I have a second Table that has field a 'Team name' that is not a primary key nor does it look up from the first table. There is no relationship set up between these two fields. The second table is populated by a Form. This Form has a combo box that fills the 'Team name field' . This combo box has in its Row Souce property a SQL Statement:Query Builder that includes The Team ID and Team name. I have a Query that is based only on the second table this query contains 'Team Names'. What I am trying to do is create a report using the report Wizard. I have done this two ways. One, using the wizard and chosen all the fields from the above query including 'Team names' and when the wizard ask if I what any grouping I Select NONE. The report, when done, has the actual "Team Names" on it (all spelled out), In the Design View, The box that contains 'Team names' is in the Detail section. The seconed way I have created a report using the wizard is, to select all the fields from the above query, including 'Team name' and when the wizard asks if I want any grouping levels I Select 'Team names'. The report, when done, has the "Team Id Numbers" on it(literally, just numbers appear). In Design View there is a section, Team Header, where the 'Team Names' Box appears. The problem is that I want the literal "Team Names" printed in the first Report(with a grouping). Soulution one is to go to the none grouped report(second report) and copy the box to out of it then past it to the grouped report(first report) replacing the 'Team names' box. This works. Soulution Two(suggested by you) is to use the wizard but when I am chosing the feilds chose the 'Team names' field from the first Table or the second table( I have tried both) this gives me an error message that I wrote out in an earlier report. The error message prevents me from going any futher with the wizard. The only way I am able at this time to chose the field 'Team name' is from the fields from the Query. "Duane Hookom" wrote: I'm lost as to what you have and what you need. If you want to display the team name in your report, your report's record source should include the table with the team name field. Is this what you have? You might need to share the SQL view of your report's record source. You can use combo boxes on forms so that you end up storing the primary key from the lookup table in the related tables. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... O', and by the way since I took all the look up fields out(and this didn't fix the problem), I figued it was the query in the row source property that populated my combo box it did have the Team ID and the Team Name. I tried to remove the Team ID but the combo box wouldn't work then. Thanks, Kurt "Duane Hookom" wrote: Regarding lookup fields, check this page http://www.mvps.org/access/lookupfields.htm. Is your report now working as expected? -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... Did you use a lookup field in a table? Originally, but after your post I changed that, but it did not change the outcome. Did your original query contain the team name field? Yes it did. I changed that after you post and the error message still appeared. Did you expect a table with the team ID value to automatically include the team name table in the report? Yes I did. Since the wizard produced the Team names in the report when I did not use the the Team name as a header, I figured it would produce the same results when I chose the Team name as a header. I am unclear as to why using the look up field is bad. Are there times when it is good? "Duane Hookom" wrote: Did you use a lookup field in a table? Did your original query contain the team name field? Did you expect a table with the team ID value to automatically include the team name table in the report? If you used a lookup field in a table, again, suggestiondon't/suggestion. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... I Just fixed it . It must have had somthing to do with the original Table that the query was based on that filled the report. The Report Where I didn't have a Team Header had the combo box arrow still with it (of course it doesn't work). The report with the Team Header did not have the combo box arrow. I copied the box with the arrow to the report with the header and it worked. Why the "Wizard" did this I don't understand. "Duane Hookom" wrote: If you place a field in your report that contains the team name text then it will display the team name text. Did you use a lookup field in your table? If so, get rid of it since it seems to be causing you confusion. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... I Tried This and it did'nt work. Does the Same thing. I don't understand...I create a form with this Team field not being a Header and it prints Just fine. I Change that, using the "Wizard" again and it returns a number. "Duane Hookom" wrote: Place the table that actually contains the team name in the report's record source. This will allow you to place the real team name in your report. BTW: most of us recommend against using lookup fields in tables. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... When use the Report Wizard to Create a Report If I don't Create and groupings it Prints the name of the team I want but when I put the team as a header it prints the team number. The Souce of the Fields is a Query. I would like to Print the Team Name as a header not the number. Why does it change? |
#14
|
|||
|
|||
Field Prints Different When I change it to heading.
You stated:
===== Quote ============================ This Form has a combo box that fills the 'Team name field' . This combo box has in its Row Souce property a SQL Statement:Query Builder that includes The Team ID and Team name. ================================= What are these properties of the combo box: Control Source: Row Source: Column Count: Bound Column: Column Widths: I expect that even though you have names the field Team Names, it actually is storing the Team ID. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... I'm lost as to what you have and what you need. ***Sorry this can be a little difficult to articulate for me. I'll try again. If you want to display the team name in your report, your report's record source should include the table with the team name field. *** I agree, but I get an error message when I try to do so. The error message I reported above. Is this what you have? No, because of the error message I am prevented from doing so. What I am forced to do instead is use the team name from the Query that creates the data for the report. You might need to share the SQL view of your report's record source. ***This I do not understand. Here I'll try again to be clear about what I have and what I am trying to do and what problem arises when I try to do this. Please not that I have no look up fields( these have been removed on you suggestion). I will then Try to be clear about what happens when I try your solution. What I have: a Table that has a field of 'Team names' and a field of 'Team ID' numbers that is the primary key for this table. I have a second Table that has field a 'Team name' that is not a primary key nor does it look up from the first table. There is no relationship set up between these two fields. The second table is populated by a Form. This Form has a combo box that fills the 'Team name field' . This combo box has in its Row Souce property a SQL Statement:Query Builder that includes The Team ID and Team name. I have a Query that is based only on the second table this query contains 'Team Names'. What I am trying to do is create a report using the report Wizard. I have done this two ways. One, using the wizard and chosen all the fields from the above query including 'Team names' and when the wizard ask if I what any grouping I Select NONE. The report, when done, has the actual "Team Names" on it (all spelled out), In the Design View, The box that contains 'Team names' is in the Detail section. The seconed way I have created a report using the wizard is, to select all the fields from the above query, including 'Team name' and when the wizard asks if I want any grouping levels I Select 'Team names'. The report, when done, has the "Team Id Numbers" on it(literally, just numbers appear). In Design View there is a section, Team Header, where the 'Team Names' Box appears. The problem is that I want the literal "Team Names" printed in the first Report(with a grouping). Soulution one is to go to the none grouped report(second report) and copy the box to out of it then past it to the grouped report(first report) replacing the 'Team names' box. This works. Soulution Two(suggested by you) is to use the wizard but when I am chosing the feilds chose the 'Team names' field from the first Table or the second table( I have tried both) this gives me an error message that I wrote out in an earlier report. The error message prevents me from going any futher with the wizard. The only way I am able at this time to chose the field 'Team name' is from the fields from the Query. "Duane Hookom" wrote: I'm lost as to what you have and what you need. If you want to display the team name in your report, your report's record source should include the table with the team name field. Is this what you have? You might need to share the SQL view of your report's record source. You can use combo boxes on forms so that you end up storing the primary key from the lookup table in the related tables. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... O', and by the way since I took all the look up fields out(and this didn't fix the problem), I figued it was the query in the row source property that populated my combo box it did have the Team ID and the Team Name. I tried to remove the Team ID but the combo box wouldn't work then. Thanks, Kurt "Duane Hookom" wrote: Regarding lookup fields, check this page http://www.mvps.org/access/lookupfields.htm. Is your report now working as expected? -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... Did you use a lookup field in a table? Originally, but after your post I changed that, but it did not change the outcome. Did your original query contain the team name field? Yes it did. I changed that after you post and the error message still appeared. Did you expect a table with the team ID value to automatically include the team name table in the report? Yes I did. Since the wizard produced the Team names in the report when I did not use the the Team name as a header, I figured it would produce the same results when I chose the Team name as a header. I am unclear as to why using the look up field is bad. Are there times when it is good? "Duane Hookom" wrote: Did you use a lookup field in a table? Did your original query contain the team name field? Did you expect a table with the team ID value to automatically include the team name table in the report? If you used a lookup field in a table, again, suggestiondon't/suggestion. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... I Just fixed it . It must have had somthing to do with the original Table that the query was based on that filled the report. The Report Where I didn't have a Team Header had the combo box arrow still with it (of course it doesn't work). The report with the Team Header did not have the combo box arrow. I copied the box with the arrow to the report with the header and it worked. Why the "Wizard" did this I don't understand. "Duane Hookom" wrote: If you place a field in your report that contains the team name text then it will display the team name text. Did you use a lookup field in your table? If so, get rid of it since it seems to be causing you confusion. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... I Tried This and it did'nt work. Does the Same thing. I don't understand...I create a form with this Team field not being a Header and it prints Just fine. I Change that, using the "Wizard" again and it returns a number. "Duane Hookom" wrote: Place the table that actually contains the team name in the report's record source. This will allow you to place the real team name in your report. BTW: most of us recommend against using lookup fields in tables. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... When use the Report Wizard to Create a Report If I don't Create and groupings it Prints the name of the team I want but when I put the team as a header it prints the team number. The Souce of the Fields is a Query. I would like to Print the Team Name as a header not the number. Why does it change? |
#15
|
|||
|
|||
Field Prints Different When I change it to heading.
Yea, I think that's the problem. I have put the Properties into this reply
below: What are these properties of the combo box: Control Source: "Table/Query Row Source: "SELECT [Team List].[Team ID], [Team List].[Team Name] FROM [Team List] ORDER BY [Team List].[Team Name]; Column Count: "2" Bound Column: "1" Column Widths: "O";1" Thank You. "Duane Hookom" wrote: You stated: ===== Quote ============================ This Form has a combo box that fills the 'Team name field' . This combo box has in its Row Souce property a SQL Statement:Query Builder that includes The Team ID and Team name. ================================= What are these properties of the combo box: Control Source: "Table/Query Row Source: "SELECT [Team List].[Team ID], [Team List].[Team Name] FROM [Team List] ORDER BY [Team List].[Team Name]; Column Count: "2" Bound Column: "1" Column Widths: "O";1" I expect that even though you have names the field Team Names, it actually is storing the Team ID. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... I'm lost as to what you have and what you need. ***Sorry this can be a little difficult to articulate for me. I'll try again. If you want to display the team name in your report, your report's record source should include the table with the team name field. *** I agree, but I get an error message when I try to do so. The error message I reported above. Is this what you have? No, because of the error message I am prevented from doing so. What I am forced to do instead is use the team name from the Query that creates the data for the report. You might need to share the SQL view of your report's record source. ***This I do not understand. Here I'll try again to be clear about what I have and what I am trying to do and what problem arises when I try to do this. Please not that I have no look up fields( these have been removed on you suggestion). I will then Try to be clear about what happens when I try your solution. What I have: a Table that has a field of 'Team names' and a field of 'Team ID' numbers that is the primary key for this table. I have a second Table that has field a 'Team name' that is not a primary key nor does it look up from the first table. There is no relationship set up between these two fields. The second table is populated by a Form. This Form has a combo box that fills the 'Team name field' . This combo box has in its Row Souce property a SQL Statement:Query Builder that includes The Team ID and Team name. I have a Query that is based only on the second table this query contains 'Team Names'. What I am trying to do is create a report using the report Wizard. I have done this two ways. One, using the wizard and chosen all the fields from the above query including 'Team names' and when the wizard ask if I what any grouping I Select NONE. The report, when done, has the actual "Team Names" on it (all spelled out), In the Design View, The box that contains 'Team names' is in the Detail section. The seconed way I have created a report using the wizard is, to select all the fields from the above query, including 'Team name' and when the wizard asks if I want any grouping levels I Select 'Team names'. The report, when done, has the "Team Id Numbers" on it(literally, just numbers appear). In Design View there is a section, Team Header, where the 'Team Names' Box appears. The problem is that I want the literal "Team Names" printed in the first Report(with a grouping). Soulution one is to go to the none grouped report(second report) and copy the box to out of it then past it to the grouped report(first report) replacing the 'Team names' box. This works. Soulution Two(suggested by you) is to use the wizard but when I am chosing the feilds chose the 'Team names' field from the first Table or the second table( I have tried both) this gives me an error message that I wrote out in an earlier report. The error message prevents me from going any futher with the wizard. The only way I am able at this time to chose the field 'Team name' is from the fields from the Query. "Duane Hookom" wrote: I'm lost as to what you have and what you need. If you want to display the team name in your report, your report's record source should include the table with the team name field. Is this what you have? You might need to share the SQL view of your report's record source. You can use combo boxes on forms so that you end up storing the primary key from the lookup table in the related tables. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... O', and by the way since I took all the look up fields out(and this didn't fix the problem), I figued it was the query in the row source property that populated my combo box it did have the Team ID and the Team Name. I tried to remove the Team ID but the combo box wouldn't work then. Thanks, Kurt "Duane Hookom" wrote: Regarding lookup fields, check this page http://www.mvps.org/access/lookupfields.htm. Is your report now working as expected? -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... Did you use a lookup field in a table? Originally, but after your post I changed that, but it did not change the outcome. Did your original query contain the team name field? Yes it did. I changed that after you post and the error message still appeared. Did you expect a table with the team ID value to automatically include the team name table in the report? Yes I did. Since the wizard produced the Team names in the report when I did not use the the Team name as a header, I figured it would produce the same results when I chose the Team name as a header. I am unclear as to why using the look up field is bad. Are there times when it is good? "Duane Hookom" wrote: Did you use a lookup field in a table? Did your original query contain the team name field? Did you expect a table with the team ID value to automatically include the team name table in the report? If you used a lookup field in a table, again, suggestiondon't/suggestion. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... I Just fixed it . It must have had somthing to do with the original Table that the query was based on that filled the report. The Report Where I didn't have a Team Header had the combo box arrow still with it (of course it doesn't work). The report with the Team Header did not have the combo box arrow. I copied the box with the arrow to the report with the header and it worked. Why the "Wizard" did this I don't understand. "Duane Hookom" wrote: If you place a field in your report that contains the team name text then it will display the team name text. Did you use a lookup field in your table? If so, get rid of it since it seems to be causing you confusion. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... I Tried This and it did'nt work. Does the Same thing. I don't understand...I create a form with this Team field not being a Header and it prints Just fine. I Change that, using the "Wizard" again and it returns a number. "Duane Hookom" wrote: Place the table that actually contains the team name in the report's record source. This will allow you to place the real team name in your report. BTW: most of us recommend against using lookup fields in tables. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... When use the Report Wizard to Create a Report If I don't Create and groupings it Prints the name of the team I want but when I put the team as a header it prints the team number. The Souce of the Fields is a Query. I would like to Print the Team Name as a header not the number. Why does it change? |
#16
|
|||
|
|||
Field Prints Different When I change it to heading.
Your report needs to have the table [Team List] in its record source. This
table will be joined based on the [Team ID] (I think). You actually provided the "Row Source Type" rather than the "Control Source". -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... Yea, I think that's the problem. I have put the Properties into this reply below: What are these properties of the combo box: Control Source: "Table/Query Row Source: "SELECT [Team List].[Team ID], [Team List].[Team Name] FROM [Team List] ORDER BY [Team List].[Team Name]; Column Count: "2" Bound Column: "1" Column Widths: "O";1" Thank You. "Duane Hookom" wrote: You stated: ===== Quote ============================ This Form has a combo box that fills the 'Team name field' . This combo box has in its Row Souce property a SQL Statement:Query Builder that includes The Team ID and Team name. ================================= What are these properties of the combo box: Control Source: "Table/Query Row Source: "SELECT [Team List].[Team ID], [Team List].[Team Name] FROM [Team List] ORDER BY [Team List].[Team Name]; Column Count: "2" Bound Column: "1" Column Widths: "O";1" I expect that even though you have names the field Team Names, it actually is storing the Team ID. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... I'm lost as to what you have and what you need. ***Sorry this can be a little difficult to articulate for me. I'll try again. If you want to display the team name in your report, your report's record source should include the table with the team name field. *** I agree, but I get an error message when I try to do so. The error message I reported above. Is this what you have? No, because of the error message I am prevented from doing so. What I am forced to do instead is use the team name from the Query that creates the data for the report. You might need to share the SQL view of your report's record source. ***This I do not understand. Here I'll try again to be clear about what I have and what I am trying to do and what problem arises when I try to do this. Please not that I have no look up fields( these have been removed on you suggestion). I will then Try to be clear about what happens when I try your solution. What I have: a Table that has a field of 'Team names' and a field of 'Team ID' numbers that is the primary key for this table. I have a second Table that has field a 'Team name' that is not a primary key nor does it look up from the first table. There is no relationship set up between these two fields. The second table is populated by a Form. This Form has a combo box that fills the 'Team name field' . This combo box has in its Row Souce property a SQL Statement:Query Builder that includes The Team ID and Team name. I have a Query that is based only on the second table this query contains 'Team Names'. What I am trying to do is create a report using the report Wizard. I have done this two ways. One, using the wizard and chosen all the fields from the above query including 'Team names' and when the wizard ask if I what any grouping I Select NONE. The report, when done, has the actual "Team Names" on it (all spelled out), In the Design View, The box that contains 'Team names' is in the Detail section. The seconed way I have created a report using the wizard is, to select all the fields from the above query, including 'Team name' and when the wizard asks if I want any grouping levels I Select 'Team names'. The report, when done, has the "Team Id Numbers" on it(literally, just numbers appear). In Design View there is a section, Team Header, where the 'Team Names' Box appears. The problem is that I want the literal "Team Names" printed in the first Report(with a grouping). Soulution one is to go to the none grouped report(second report) and copy the box to out of it then past it to the grouped report(first report) replacing the 'Team names' box. This works. Soulution Two(suggested by you) is to use the wizard but when I am chosing the feilds chose the 'Team names' field from the first Table or the second table( I have tried both) this gives me an error message that I wrote out in an earlier report. The error message prevents me from going any futher with the wizard. The only way I am able at this time to chose the field 'Team name' is from the fields from the Query. "Duane Hookom" wrote: I'm lost as to what you have and what you need. If you want to display the team name in your report, your report's record source should include the table with the team name field. Is this what you have? You might need to share the SQL view of your report's record source. You can use combo boxes on forms so that you end up storing the primary key from the lookup table in the related tables. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... O', and by the way since I took all the look up fields out(and this didn't fix the problem), I figued it was the query in the row source property that populated my combo box it did have the Team ID and the Team Name. I tried to remove the Team ID but the combo box wouldn't work then. Thanks, Kurt "Duane Hookom" wrote: Regarding lookup fields, check this page http://www.mvps.org/access/lookupfields.htm. Is your report now working as expected? -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... Did you use a lookup field in a table? Originally, but after your post I changed that, but it did not change the outcome. Did your original query contain the team name field? Yes it did. I changed that after you post and the error message still appeared. Did you expect a table with the team ID value to automatically include the team name table in the report? Yes I did. Since the wizard produced the Team names in the report when I did not use the the Team name as a header, I figured it would produce the same results when I chose the Team name as a header. I am unclear as to why using the look up field is bad. Are there times when it is good? "Duane Hookom" wrote: Did you use a lookup field in a table? Did your original query contain the team name field? Did you expect a table with the team ID value to automatically include the team name table in the report? If you used a lookup field in a table, again, suggestiondon't/suggestion. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... I Just fixed it . It must have had somthing to do with the original Table that the query was based on that filled the report. The Report Where I didn't have a Team Header had the combo box arrow still with it (of course it doesn't work). The report with the Team Header did not have the combo box arrow. I copied the box with the arrow to the report with the header and it worked. Why the "Wizard" did this I don't understand. "Duane Hookom" wrote: If you place a field in your report that contains the team name text then it will display the team name text. Did you use a lookup field in your table? If so, get rid of it since it seems to be causing you confusion. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... I Tried This and it did'nt work. Does the Same thing. I don't understand...I create a form with this Team field not being a Header and it prints Just fine. I Change that, using the "Wizard" again and it returns a number. "Duane Hookom" wrote: Place the table that actually contains the team name in the report's record source. This will allow you to place the real team name in your report. BTW: most of us recommend against using lookup fields in tables. -- Duane Hookom MS Access MVP -- "domdog" wrote in message ... When use the Report Wizard to Create a Report If I don't Create and groupings it Prints the name of the team I want but when I put the team as a header it prints the team number. The Souce of the Fields is a Query. I would like to Print the Team Name as a header not the number. Why does it change? |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how do you change the email address field for all contacts? | Mike Bailey | Contacts | 1 | January 10th, 2006 12:15 PM |
How to generate bilingual docments with captions and toc | Markus | General Discussion | 1 | November 19th, 2005 07:11 AM |
conditional Change of field properties in a report | Frank | Setting Up & Running Reports | 3 | January 6th, 2005 08:56 PM |
Chapter Headings "continued" | db | Formatting Long Documents | 2 | November 5th, 2004 09:34 PM |
Supress blank lines in DOCPROPERTY field | Mary | Formatting Long Documents | 10 | May 25th, 2004 07:27 PM |