Re: Fields in Label don't give correct information
- From: "Duane Hookom" <DuaneAtNoSpanHookomDotNet>
- Date: Sat, 14 Oct 2006 00:37:00 -0500
Some of us feel lookup fields are an evil mis-feature
http://www.mvps.org/access/lookupfields.htm.
If you want to display text values in a report, you should include the
tables and fields in the report's record source that contain the actual
values, not just the ID values.
--
Duane Hookom
MS Access MVP
"Bill_De" <BillDe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FC4ECB16-B743-4FED-94A9-AA6F1D5FE3D3@xxxxxxxxxxxxxxxx
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
.
- Follow-Ups:
- Re: Fields in Label don't give correct information
- From: Bill_De
- Re: Fields in Label don't give correct information
- Prev by Date: Re: RTF2 ActiveX Control
- Next by Date: how to "justify" the text right to left?
- Previous by thread: RTF2 ActiveX Control
- Next by thread: Re: Fields in Label don't give correct information
- Index(es):
Relevant Pages
|
