Reporting with Junction Tables - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Reporting with Junction Tables

Joshua Rivera

3 years ago

Hello:

I'm trying to pull the Values that are stored in my Main Tables, and referenced in a Junction Table.

The Data that I want to reference in my report is based on the Junction Table, However, I'm only presented with the numerical Auto Number for the value and not the Value itself.

How do I change this to present the Main value and not the associated numerical Auto Number?

	Kevin Robertson @Reply 3 years ago
Bring all the required tables in to a Query and add the fields you want in your Report to that Query.

	Joshua Rivera OP @Reply 3 years ago
Are you saying that in order to have the value presented, I need to have the main tables relational to the Junction Table in the query to get the Value to display?

	Joshua Rivera OP @Reply 3 years ago

	Joshua Rivera OP @Reply 3 years ago
Each of the Tables on the right are Junction Tables, the CaseFileT is not a Junction Table.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View