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