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?

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?

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?

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?

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?

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?