Why does my report display a value different than that of the que.

  • Thread starter Thread starter AEH&H
  • Start date Start date
A

AEH&H

I am running a report based on a query. For some reason the result displayed
on the report is not that in the query: in the query the result displayed
properly from the table is "Tune-Up Kit". On the report it shows up as "14".
Any ideas?

I had a simular issue yesterday when displaying a calculated value. I ended
up going in the original table and deleting the record and reentered the
data. It then worked fine. Also - when running the query I received a
trusted source warning that I said ok to - I have secured the location so I
did not get that either. Perhaps none of this is related but thought I would
mention it.

Thanks
 
First guess, you're using a Lookup field in the table, so that the field
displays a name but actually stores the ID of that name in the table. The
report is showing you the ID and not the name, which is correct behavior for
the report to do. Change the query to use the Name/Description field and not
the ID field.
 
First guess, you're using a Lookup field in the table, so that the field
displays a name but actually stores the ID of that name in the table. The
report is showing you the ID and not the name, which is correct behavior for
the report to do. Change the query to use the Name/Description field and not
the ID field.
 
Thanks for the input. You are exactly on! My query is calling the
description field but it was selected in the tabled being queried with a
look-up table. I am not sure what to change. In the table on the row source
it reads: SELECT [Part Number / Pricing Table].[ID], [Part Number / Pricing
Table].[Description], [Part Number / Pricing Table].[Part Number] FROM [Part
Number / Pricing Table] ORDER BY [Part Number]; Any further advice?
 
Thanks for the input. You are exactly on! My query is calling the
description field but it was selected in the tabled being queried with a
look-up table. I am not sure what to change. In the table on the row source
it reads: SELECT [Part Number / Pricing Table].[ID], [Part Number / Pricing
Table].[Description], [Part Number / Pricing Table].[Part Number] FROM [Part
Number / Pricing Table] ORDER BY [Part Number]; Any further advice?
 
Also - The proper decription is diplayed in the query the report is being run
from.

AEH&H said:
Thanks for the input. You are exactly on! My query is calling the
description field but it was selected in the tabled being queried with a
look-up table. I am not sure what to change. In the table on the row source
it reads: SELECT [Part Number / Pricing Table].[ID], [Part Number / Pricing
Table].[Description], [Part Number / Pricing Table].[Part Number] FROM [Part
Number / Pricing Table] ORDER BY [Part Number]; Any further advice?

Ken Snell said:
First guess, you're using a Lookup field in the table, so that the field
displays a name but actually stores the ID of that name in the table. The
report is showing you the ID and not the name, which is correct behavior for
the report to do. Change the query to use the Name/Description field and not
the ID field.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
Click to expand...
Click to expand...
 
Also - The proper decription is diplayed in the query the report is being run
from.

AEH&H said:
Thanks for the input. You are exactly on! My query is calling the
description field but it was selected in the tabled being queried with a
look-up table. I am not sure what to change. In the table on the row source
it reads: SELECT [Part Number / Pricing Table].[ID], [Part Number / Pricing
Table].[Description], [Part Number / Pricing Table].[Part Number] FROM [Part
Number / Pricing Table] ORDER BY [Part Number]; Any further advice?

Ken Snell said:
First guess, you're using a Lookup field in the table, so that the field
displays a name but actually stores the ID of that name in the table. The
report is showing you the ID and not the name, which is correct behavior for
the report to do. Change the query to use the Name/Description field and not
the ID field.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
Click to expand...
Click to expand...
 
To which field is the textbox on your report bound, the textbox that is
displaying the 14? I assume ID. Change the ControlSource of that textbox to
Description.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


AEH&H said:
Also - The proper decription is diplayed in the query the report is being
run
from.

AEH&H said:
Thanks for the input. You are exactly on! My query is calling the
description field but it was selected in the tabled being queried with a
look-up table. I am not sure what to change. In the table on the row
source
it reads: SELECT [Part Number / Pricing Table].[ID], [Part Number /
Pricing
Table].[Description], [Part Number / Pricing Table].[Part Number] FROM
[Part
Number / Pricing Table] ORDER BY [Part Number]; Any further advice?

Ken Snell said:
First guess, you're using a Lookup field in the table, so that the
field
displays a name but actually stores the ID of that name in the table.
The
report is showing you the ID and not the name, which is correct
behavior for
the report to do. Change the query to use the Name/Description field
and not
the ID field.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


I am running a report based on a query. For some reason the result
displayed
on the report is not that in the query: in the query the result
displayed
properly from the table is "Tune-Up Kit". On the report it shows up
as
"14".
Any ideas?

I had a simular issue yesterday when displaying a calculated value.
I
ended
up going in the original table and deleting the record and reentered
the
data. It then worked fine. Also - when running the query I received
a
trusted source warning that I said ok to - I have secured the
location so
I
did not get that either. Perhaps none of this is related but thought
I
would
mention it.

Thanks
Click to expand...
Click to expand...
Click to expand...
 
To which field is the textbox on your report bound, the textbox that is
displaying the 14? I assume ID. Change the ControlSource of that textbox to
Description.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


AEH&H said:
Also - The proper decription is diplayed in the query the report is being
run
from.

AEH&H said:
Thanks for the input. You are exactly on! My query is calling the
description field but it was selected in the tabled being queried with a
look-up table. I am not sure what to change. In the table on the row
source
it reads: SELECT [Part Number / Pricing Table].[ID], [Part Number /
Pricing
Table].[Description], [Part Number / Pricing Table].[Part Number] FROM
[Part
Number / Pricing Table] ORDER BY [Part Number]; Any further advice?

Ken Snell said:
First guess, you're using a Lookup field in the table, so that the
field
displays a name but actually stores the ID of that name in the table.
The
report is showing you the ID and not the name, which is correct
behavior for
the report to do. Change the query to use the Name/Description field
and not
the ID field.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


I am running a report based on a query. For some reason the result
displayed
on the report is not that in the query: in the query the result
displayed
properly from the table is "Tune-Up Kit". On the report it shows up
as
"14".
Any ideas?

I had a simular issue yesterday when displaying a calculated value.
I
ended
up going in the original table and deleting the record and reentered
the
data. It then worked fine. Also - when running the query I received
a
trusted source warning that I said ok to - I have secured the
location so
I
did not get that either. Perhaps none of this is related but thought
I
would
mention it.

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Actually, you will need to change the query, assuming that you want the
description of the part number to be displayed. In the following query,
change NameOfYourPartNumberTable to the real name of the table that holds
your part numbers, and change NameOfPartNumberDescriptionField to the real
name of the field in that part number table that holds the part description.


SELECT [Part Number / Pricing Table].[ID], [Part Number / Pricing
Table].[Description], [Part Number / Pricing Table].[Part Number],
NameOfYourPartNumberTable.NameOfPartNumberDescriptionField
FROM [Part Number / Pricing Table] INNER JOIN
NameOfYourPartNumberTable
ON [Part Number / Pricing Table].[Part Number] =
NameOfYourPartNumberTable.[Part Number]
ORDER BY [Part Number];


--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


Ken Snell said:
To which field is the textbox on your report bound, the textbox that is
displaying the 14? I assume ID. Change the ControlSource of that textbox
to Description.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


AEH&H said:
Also - The proper decription is diplayed in the query the report is being
run
from.

AEH&H said:
Thanks for the input. You are exactly on! My query is calling the
description field but it was selected in the tabled being queried with a
look-up table. I am not sure what to change. In the table on the row
source
it reads: SELECT [Part Number / Pricing Table].[ID], [Part Number /
Pricing
Table].[Description], [Part Number / Pricing Table].[Part Number] FROM
[Part
Number / Pricing Table] ORDER BY [Part Number]; Any further advice?

:

First guess, you're using a Lookup field in the table, so that the
field
displays a name but actually stores the ID of that name in the table.
The
report is showing you the ID and not the name, which is correct
behavior for
the report to do. Change the query to use the Name/Description field
and not
the ID field.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


I am running a report based on a query. For some reason the result
displayed
on the report is not that in the query: in the query the result
displayed
properly from the table is "Tune-Up Kit". On the report it shows up
as
"14".
Any ideas?

I had a simular issue yesterday when displaying a calculated value.
I
ended
up going in the original table and deleting the record and reentered
the
data. It then worked fine. Also - when running the query I
received a
trusted source warning that I said ok to - I have secured the
location so
I
did not get that either. Perhaps none of this is related but
thought I
would
mention it.

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Actually, you will need to change the query, assuming that you want the
description of the part number to be displayed. In the following query,
change NameOfYourPartNumberTable to the real name of the table that holds
your part numbers, and change NameOfPartNumberDescriptionField to the real
name of the field in that part number table that holds the part description.


SELECT [Part Number / Pricing Table].[ID], [Part Number / Pricing
Table].[Description], [Part Number / Pricing Table].[Part Number],
NameOfYourPartNumberTable.NameOfPartNumberDescriptionField
FROM [Part Number / Pricing Table] INNER JOIN
NameOfYourPartNumberTable
ON [Part Number / Pricing Table].[Part Number] =
NameOfYourPartNumberTable.[Part Number]
ORDER BY [Part Number];


--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


Ken Snell said:
To which field is the textbox on your report bound, the textbox that is
displaying the 14? I assume ID. Change the ControlSource of that textbox
to Description.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


AEH&H said:
Also - The proper decription is diplayed in the query the report is being
run
from.

AEH&H said:
Thanks for the input. You are exactly on! My query is calling the
description field but it was selected in the tabled being queried with a
look-up table. I am not sure what to change. In the table on the row
source
it reads: SELECT [Part Number / Pricing Table].[ID], [Part Number /
Pricing
Table].[Description], [Part Number / Pricing Table].[Part Number] FROM
[Part
Number / Pricing Table] ORDER BY [Part Number]; Any further advice?

:

First guess, you're using a Lookup field in the table, so that the
field
displays a name but actually stores the ID of that name in the table.
The
report is showing you the ID and not the name, which is correct
behavior for
the report to do. Change the query to use the Name/Description field
and not
the ID field.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


I am running a report based on a query. For some reason the result
displayed
on the report is not that in the query: in the query the result
displayed
properly from the table is "Tune-Up Kit". On the report it shows up
as
"14".
Any ideas?

I had a simular issue yesterday when displaying a calculated value.
I
ended
up going in the original table and deleting the record and reentered
the
data. It then worked fine. Also - when running the query I
received a
trusted source warning that I said ok to - I have secured the
location so
I
did not get that either. Perhaps none of this is related but
thought I
would
mention it.

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top