Problem creating Labels in Access

I am hoping someone can head me in the right direction on this one. I should
tell you I am not that proficient at Access so if you can help please explain
your answer in a little detail.

In Reports I am trying to create Labels for ID badges using the Label
Wizard. When I create a report using a query to combine two tables I get all
of the fields to show the correct information, however when I open the Label
Wizard and create Labels for ID badges using the same query all I get are the
line numbers.

In my tables I have fields that have drop downs to select information for
example in by table tblEvent I have a drop down box created from the look up
wizard in tables. The drop down box allows me to select building and room
numbers.

I created a query to combine information from my tblcontacts (personal
information) and information from tblEvent this is room assignments, staff
positions, and team assignments.
When I create a report from the query I get the correct info for example
under the field "Room Assignment" I will get "Lakeview 2 A 1; Building is
Lakeview, 2 is Room number, A is Room Letter, and 1 is the bunk number.
When I create a Label using the same query all I get in the Room Assignment
field is "1" which is the autonumber in the table.

As a note in the table tblEvent for Room assignment I used the lookup wizard
and the result was: Field Name "BuildingID" - Data Type "Number"
In the field properties I have the column width set at 0";1";1"; 1"; 1" and
the row source is: SELECT [tblhousing].[BuildingID]&"
"&[tblhousing].[Building]&" "&[tblhousing].[RoomNumber]&"
"&[tblhousing].[RoomLetter]&" "&[tblhousing].[Bunk] FROM tblhousing;

Also I get this same problem if I create a label from just a table. I tried
using just the tblContacts where I have all the states in a drop down and
when I create the label and enter a state all I get in the label is the line
number.


Thanks in advance for your help
Bill_De

Bill,
You have a thread going on this question in the reports news group. Please
don't start other threads.

--
Duane Hookom
MS Access MVP

"Bill_De" wrote in message
...
I am hoping someone can head me in the right direction on this one. I
should
tell you I am not that proficient at Access so if you can help please
explain
your answer in a little detail.

In Reports I am trying to create Labels for ID badges using the Label
Wizard. When I create a report using a query to combine two tables I get
all
of the fields to show the correct information, however when I open the
Label
Wizard and create Labels for ID badges using the same query all I get are
the
line numbers.

In my tables I have fields that have drop downs to select information for
example in by table tblEvent I have a drop down box created from the look
up
wizard in tables. The drop down box allows me to select building and room
numbers.

I created a query to combine information from my tblcontacts (personal
information) and information from tblEvent this is room assignments, staff
positions, and team assignments.
When I create a report from the query I get the correct info for example
under the field "Room Assignment" I will get "Lakeview 2 A 1; Building is
Lakeview, 2 is Room number, A is Room Letter, and 1 is the bunk number.
When I create a Label using the same query all I get in the Room
Assignment
field is "1" which is the autonumber in the table.

As a note in the table tblEvent for Room assignment I used the lookup
wizard
and the result was: Field Name "BuildingID" - Data Type "Number"
In the field properties I have the column width set at 0";1";1"; 1"; 1"
and
the row source is: SELECT [tblhousing].[BuildingID]&"
"&[tblhousing].[Building]&" "&[tblhousing].[RoomNumber]&"
"&[tblhousing].[RoomLetter]&" "&[tblhousing].[Bunk] FROM tblhousing;

Also I get this same problem if I create a label from just a table. I
tried
using just the tblContacts where I have all the states in a drop down and
when I create the label and enter a state all I get in the label is the
line
number.


Thanks in advance for your help
Bill_De