[MS_AccessPros] Create a report that relates a value to an item description

 

Hi,
I'm working on a project where I have to create a report based on a query and data from different table/query. The query holds in many records, and each record holds multiple values like D1, D2, D3, Nonetheless the report needs to show these values D1, D2, D3 and the description of each one, from another table. See sample below:

Eg "D1" "Data 1 Description", "D2" "Data 2 Description", "D3" "Data 3 Description"

The values are in one table/query and the description are in another table. I have tried relating each Value in the Query/table to the Table holding the descriptions, however all values bring the same description. See below:

Eg "D1" "Data Description 1", "D2" "Data Description 1", "D3" "Data Description 1"

I believe that there could be an expression or a Query that can help me pull in the report the correct descriptions for each value. Thanks

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___