If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Problem creating Labels in Access
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 |
Thread Tools | |
Display Modes | |
|
|