ACCESS FEED: Re: [MS_AccessPros] Create a report that relates a value to an item description

Sabtu, 24 November 2012

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

what is the structure of the relevant tables and how are they related? thanks

Warm Regards,
Crystal

Learn Access on YouTube
http://www.youtube.com/LearnAccessByCrystal

*
(: have an awesome day :)
*

________________________________
From: karlytos_rivas <karlytos_rivas@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Saturday, November 24, 2012 7:17 PM
Subject: [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

[Non-text portions of this message have been removed]