Field Prints Different When I change it to heading.

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?

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?

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?

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?

Thank You for the replyes.

When I try this the "Wizard" give me an error: "You have chosen fields
from record sources which the wizard can't connect. You may have chosen
fields from a table and from a query based on that table. If so, try
choosing fields from only the table or only the query."

The only hook I can see is that the names in the original Table are filled
by a form that used combo boxes based on the Table of Teams.

"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?

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?

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?

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?

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?

Mostly yes and a little know. I cut and past the box that works into my
report with a header from one without that I just make up to get the box. I
don't like this as a soulution. The fact that the Wizard handles the
situation differently with the same input in only slightly different
circumstances does'nt seem right.

Thank You for Time.

"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?