Fields in Label don't give correct information

[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

 

[Duane Hookom]

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.

 

[Guest]

Thank you for the input but I am not having a problem with a report. My
problem is creating Labels using the label wizard in the reports section.
When I create the Label all I get is the line number (which is an
autonumber) for the field.
I created the report to see if I would get the same result in a report as I
am in the label making process. The report shows all the text information
just fine for example under Room Assignment the field shows the Building,
room number, room letter and bunk number, and under staff position when
selected it shows the position titile such as Event Coordinator.

I am using look up fields for example in the room assignment becuase I have
over 350 rooms to choose from and I have the form set up so when a room is
selected it no longer shows up on the drop down list as a choice.

But as I said in the label when I create it under Room Assignment all that
shows up is the number 1.

I am trying to find out how I can get the Label to show the same information
as the report that I created to check and make sure everything was working
correct.

Thanks
Bill_De

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

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

 

[Duane Hookom]

My answer is still the same. Your labels are a report. When you created a
standard report, your controls are probably combo boxes. Your label report
is using combo boxes.

You are using lookup fields that are causing your confusion.

I repeat:
"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

Thank you for the input but I am not having a problem with a report. My
problem is creating Labels using the label wizard in the reports section.
When I create the Label all I get is the line number (which is an
autonumber) for the field.
I created the report to see if I would get the same result in a report as
I
am in the label making process. The report shows all the text information
just fine for example under Room Assignment the field shows the Building,
room number, room letter and bunk number, and under staff position when
selected it shows the position titile such as Event Coordinator.

I am using look up fields for example in the room assignment becuase I
have
over 350 rooms to choose from and I have the form set up so when a room is
selected it no longer shows up on the drop down list as a choice.

But as I said in the label when I create it under Room Assignment all that
shows up is the number 1.

I am trying to find out how I can get the Label to show the same
information
as the report that I created to check and make sure everything was working
correct.

Thanks
Bill_De

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

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

 

[Guest]

Ok
But can you explain to me how to do that then. As I said when I create a
report all of the information shows up on the report the way I want it to.
For example in the Room assignment on the report an idividual will be
assigned to "Lakeview room 2a bunk 1. On the report it prints out the
individuals name and room assignment as: John Smith Lakeview 2a1. However
when I create the lable for his ID badge using the same query I used to
create the report I get:

John Smith
1

What I need to know is what do I have to change and where do I make the
change to get the label to show the following:

John Smith
Lakeview 2a1

I don't know where I have to make any changes at as the labels are based on
the same query as the report.

Thanks

My answer is still the same. Your labels are a report. When you created a
standard report, your controls are probably combo boxes. Your label report
is using combo boxes.

You are using lookup fields that are causing your confusion.

I repeat:
"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

Thank you for the input but I am not having a problem with a report. My
problem is creating Labels using the label wizard in the reports section.
When I create the Label all I get is the line number (which is an
autonumber) for the field.
I created the report to see if I would get the same result in a report as
I
am in the label making process. The report shows all the text information
just fine for example under Room Assignment the field shows the Building,
room number, room letter and bunk number, and under staff position when
selected it shows the position titile such as Event Coordinator.

I am using look up fields for example in the room assignment becuase I
have
over 350 rooms to choose from and I have the form set up so when a room is
selected it no longer shows up on the drop down list as a choice.

But as I said in the label when I create it under Room Assignment all that
shows up is the number 1.

I am trying to find out how I can get the Label to show the same
information
as the report that I created to check and make sure everything was working
correct.

Thanks
Bill_De

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

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

 

[Duane Hookom]

How about you provide enough information about your tables, fields, and
report's record source so we can help you find where "Lakeview room 2a bunk
1" is actually stored.

I expect you have a table with a field that stores these string/text values.
You would need to include this table in your report's record source.


--
Duane Hookom
MS Access MVP

Ok
But can you explain to me how to do that then. As I said when I create a
report all of the information shows up on the report the way I want it to.
For example in the Room assignment on the report an idividual will be
assigned to "Lakeview room 2a bunk 1. On the report it prints out the
individuals name and room assignment as: John Smith Lakeview 2a1. However
when I create the lable for his ID badge using the same query I used to
create the report I get:

John Smith
1

What I need to know is what do I have to change and where do I make the
change to get the label to show the following:

John Smith
Lakeview 2a1

I don't know where I have to make any changes at as the labels are based
on
the same query as the report.

Thanks

My answer is still the same. Your labels are a report. When you created a
standard report, your controls are probably combo boxes. Your label
report
is using combo boxes.

You are using lookup fields that are causing your confusion.

I repeat:
"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

Thank you for the input but I am not having a problem with a report. My
problem is creating Labels using the label wizard in the reports
section.
When I create the Label all I get is the line number (which is an
autonumber) for the field.
I created the report to see if I would get the same result in a report
as
I
am in the label making process. The report shows all the text
information
just fine for example under Room Assignment the field shows the
Building,
room number, room letter and bunk number, and under staff position when
selected it shows the position titile such as Event Coordinator.

I am using look up fields for example in the room assignment becuase I
have
over 350 rooms to choose from and I have the form set up so when a room
is
selected it no longer shows up on the drop down list as a choice.

But as I said in the label when I create it under Room Assignment all
that
shows up is the number 1.

I am trying to find out how I can get the Label to show the same
information
as the report that I created to check and make sure everything was
working
correct.

Thanks
Bill_De

:

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

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

 

[Guest]

Duane,
(Please see bottom also)
I am sorry to have been such a pest but you see I am still a rookie at this
Access stuff. I printed out your responses and studied them with the program
open. I was finally able to figure out the problem. When I included the
tables where the data was stored in the query the query would not run. All I
would get would be the field headings and not could not enter any data. Once
through trial and error I figured out what joins in the query to remove the
query ran fine. I then cross checked all of my other forms and reports and
eveything was working fine there also.
Now when I go to print the labels I get all of the information that I am
looking for just as I need it.

Again sorry to been such a pain. I am learning this stuff at a pretty good
pace this is my second data base and I have been able to finish it in about
half the time with very few errors (other than that label problem I had.)

One last thing I was trying to do and I don't know if it is possible and I
can't find it in my Access Bible.
Can I create a "DCount" that will only count records based on aother record.
What I am trying to do is Count the registrations using the
"RegistrationDate" in table RegEvent. I want that count to only reflect
registrations that are active and not closed based on the payment status in
table RegPayment.
The only expression I was able to come up with looking at the Access Bible
and other count or lookup text boxes is this:
=DCOUNT("[RegistrationDate]"),"tblRegEvent" WHERE
(("[SatID].[tblRegPayment]")<>Closed)
RegistrationDate= Date of Registration located in table RegEvent
TblRegEvent= All Data pertaining to the planned event to register someone
SatID= Payment Status located in table RegPayment examples: Closed- Partial
Payment - Paid in Full
TblRegPayment- All data pertaining to payments and fees for the registration

If the above expression is incorrect and it is possible to do a DCOUNT and
limit the records counted could you please give me the correct expression to
write.

Thanks and this should be my last inquire that I need.

Bill_De

How about you provide enough information about your tables, fields, and
report's record source so we can help you find where "Lakeview room 2a bunk
1" is actually stored.

I expect you have a table with a field that stores these string/text values.
You would need to include this table in your report's record source.


--
Duane Hookom
MS Access MVP

Ok
But can you explain to me how to do that then. As I said when I create a
report all of the information shows up on the report the way I want it to.
For example in the Room assignment on the report an idividual will be
assigned to "Lakeview room 2a bunk 1. On the report it prints out the
individuals name and room assignment as: John Smith Lakeview 2a1. However
when I create the lable for his ID badge using the same query I used to
create the report I get:

John Smith
1

What I need to know is what do I have to change and where do I make the
change to get the label to show the following:

John Smith
Lakeview 2a1

I don't know where I have to make any changes at as the labels are based
on
the same query as the report.

Thanks

My answer is still the same. Your labels are a report. When you created a
standard report, your controls are probably combo boxes. Your label
report
is using combo boxes.

You are using lookup fields that are causing your confusion.

I repeat:
"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

Thank you for the input but I am not having a problem with a report. My
problem is creating Labels using the label wizard in the reports
section.
When I create the Label all I get is the line number (which is an
autonumber) for the field.
I created the report to see if I would get the same result in a report
as
I
am in the label making process. The report shows all the text
information
just fine for example under Room Assignment the field shows the
Building,
room number, room letter and bunk number, and under staff position when
selected it shows the position titile such as Event Coordinator.

I am using look up fields for example in the room assignment becuase I
have
over 350 rooms to choose from and I have the form set up so when a room
is
selected it no longer shows up on the drop down list as a choice.

But as I said in the label when I create it under Room Assignment all
that
shows up is the number 1.

I am trying to find out how I can get the Label to show the same
information
as the report that I created to check and make sure everything was
working
correct.

Thanks
Bill_De

:

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

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

 

[Duane Hookom]

You need to create a query based on tblRegEvent and tblRegPayment. This
should clearly identify the payment status. You should then be able to use
something like:

=DCount("[RegistrationDate]","[query name]","[SatID] <> 'Closed'")

Keep in mind a few recommendations:
-Lookup fields in tables are evil
-when referring to a table and field, use
[TableName].[FieldName]
-If your DCount() is to count values in your report, don't use DCount().
There is a more efficient method.
-Don't be sorry about asking lots of questions. Just read replies carefully
and try respond to all questions from those who are attempting
to help you.
-If you have a new question, it is generally best to begin a new thread.

--
Duane Hookom
MS Access MVP

Duane,
(Please see bottom also)
I am sorry to have been such a pest but you see I am still a rookie at
this
Access stuff. I printed out your responses and studied them with the
program
open. I was finally able to figure out the problem. When I included the
tables where the data was stored in the query the query would not run. All
I
would get would be the field headings and not could not enter any data.
Once
through trial and error I figured out what joins in the query to remove
the
query ran fine. I then cross checked all of my other forms and reports and
eveything was working fine there also.
Now when I go to print the labels I get all of the information that I am
looking for just as I need it.

Again sorry to been such a pain. I am learning this stuff at a pretty good
pace this is my second data base and I have been able to finish it in
about
half the time with very few errors (other than that label problem I had.)

One last thing I was trying to do and I don't know if it is possible and I
can't find it in my Access Bible.
Can I create a "DCount" that will only count records based on aother
record.
What I am trying to do is Count the registrations using the
"RegistrationDate" in table RegEvent. I want that count to only reflect
registrations that are active and not closed based on the payment status
in
table RegPayment.
The only expression I was able to come up with looking at the Access Bible
and other count or lookup text boxes is this:
=DCOUNT("[RegistrationDate]"),"tblRegEvent" WHERE
(("[SatID].[tblRegPayment]")<>Closed)
RegistrationDate= Date of Registration located in table RegEvent
TblRegEvent= All Data pertaining to the planned event to register someone
SatID= Payment Status located in table RegPayment examples: Closed-
Partial
Payment - Paid in Full
TblRegPayment- All data pertaining to payments and fees for the
registration

If the above expression is incorrect and it is possible to do a DCOUNT and
limit the records counted could you please give me the correct expression
to
write.

Thanks and this should be my last inquire that I need.

Bill_De

How about you provide enough information about your tables, fields, and
report's record source so we can help you find where "Lakeview room 2a
bunk
1" is actually stored.

I expect you have a table with a field that stores these string/text
values.
You would need to include this table in your report's record source.


--
Duane Hookom
MS Access MVP

Ok
But can you explain to me how to do that then. As I said when I create
a
report all of the information shows up on the report the way I want it
to.
For example in the Room assignment on the report an idividual will be
assigned to "Lakeview room 2a bunk 1. On the report it prints out the
individuals name and room assignment as: John Smith Lakeview 2a1.
However
when I create the lable for his ID badge using the same query I used to
create the report I get:

John Smith
1

What I need to know is what do I have to change and where do I make the
change to get the label to show the following:

John Smith
Lakeview 2a1

I don't know where I have to make any changes at as the labels are
based
on
the same query as the report.

Thanks

:

My answer is still the same. Your labels are a report. When you
created a
standard report, your controls are probably combo boxes. Your label
report
is using combo boxes.

You are using lookup fields that are causing your confusion.

I repeat:
"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

Thank you for the input but I am not having a problem with a report.
My
problem is creating Labels using the label wizard in the reports
section.
When I create the Label all I get is the line number (which is an
autonumber) for the field.
I created the report to see if I would get the same result in a
report
as
I
am in the label making process. The report shows all the text
information
just fine for example under Room Assignment the field shows the
Building,
room number, room letter and bunk number, and under staff position
when
selected it shows the position titile such as Event Coordinator.

I am using look up fields for example in the room assignment becuase
I
have
over 350 rooms to choose from and I have the form set up so when a
room
is
selected it no longer shows up on the drop down list as a choice.

But as I said in the label when I create it under Room Assignment
all
that
shows up is the number 1.

I am trying to find out how I can get the Label to show the same
information
as the report that I created to check and make sure everything was
working
correct.

Thanks
Bill_De

:

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

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