UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Want Report To Show A Value In A Record Instead Of The Id, Access 2010    
 
   
Dave14867
post Nov 23 2017, 09:03 AM
Post#1



Posts: 44
Joined: 28-November 16



Hello all,

I am trying to generate a report from a query and need to know how to resolve an issue. The query returns an ID of an item, as it should, but I want the report to show a value of a field that is associated with that ID.

EXAMPLE: The query returns an ID of 7 for the associated record, that record contains a number of 67283 in the "Lot Number" field which is all correct however when I generate a report I want 67283 to appear in the report and not 7, does that make sense?

How do I set this up to work correctly?


Got it resolved, thanks

Thanks

Dave
Go to the top of the page
 
projecttoday
post Nov 23 2017, 09:21 AM
Post#2


UtterAccess VIP
Posts: 8,682
Joined: 10-February 04
From: South Charleston, WV


You need to modify the query so the table which contains the lot number is joined in. Beware of inner joins, however. If there is no record with the lot number the other record won't appear in the result. You can correct this with a right/left join.

--------------------
Robert Crouser

My company's website
Go to the top of the page
 
GroverParkGeorge
post Nov 23 2017, 09:22 AM
Post#3


UA Admin
Posts: 31,216
Joined: 20-June 02
From: Newcastle, WA


I'm glad to hear you resolved the problem, although you didn't specify that solution.

Am I right in assuming that you realized you need to include the related table--the one with the Lot Number--in the query that provides records for this report?

--------------------
Go to the top of the page
 
Dave14867
post Nov 23 2017, 09:59 AM
Post#4



Posts: 44
Joined: 28-November 16



GroverParkGeorge,

Yes you are correct, I didn't have the other table with the link in the query, putting that in, and including the field from that table in my query resolved my issue.

Thanks

Dave
Go to the top of the page
 
projecttoday
post Nov 23 2017, 04:40 PM
Post#5


UtterAccess VIP
Posts: 8,682
Joined: 10-February 04
From: South Charleston, WV


Even though I was first (by 1 minute) my post receives no recognition?

--------------------
Robert Crouser

My company's website
Go to the top of the page
 
Dave14867
post Nov 23 2017, 10:04 PM
Post#6



Posts: 44
Joined: 28-November 16



sorry,

ProjecttoDay, you also were correct, I didn't intentionally leave you out.

Thanks to both of you.

Dave
Go to the top of the page
 
projecttoday
post Nov 23 2017, 10:09 PM
Post#7


UtterAccess VIP
Posts: 8,682
Joined: 10-February 04
From: South Charleston, WV


thumbup.gif

--------------------
Robert Crouser

My company's website
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    14th December 2017 - 09:32 PM