Field Prints Different When I change it to heading.

[domdog]

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?

 

[Duane Hookom]

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.

 

[domdog]

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]

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.

 

[domdog]

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.

 

[domdog]

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]

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,
<suggestion>don't</suggestion>.

 

[domdog]

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]

Regarding lookup fields, check this page
http://www.mvps.org/access/lookupfields.htm.

Is your report now working as expected?

 

[domdog]

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.

 

[domdog]

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]

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.

 

[domdog]

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]

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.

 

[domdog]

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.

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"

 

[Duane Hookom]

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

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.

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.