Hi John, and thanks for your suggestion, I also thought of creating duplicates tables holding the description of these codes and relate them to each individual data field from the "Coded Data" table, but I feel that's way too much duplicity, since there are 25 "D1, D2, D3" fields and there a more than 14,756 possible descriptions to these data fields.
There must be an easier way for Access 2007 to identify the value of the D1, D2,D3, fields in the "Coded Data" Table and look up their description in the table that holds the description of the codes.
All I need is for the description of these codes D1, D2, D3 to show in a report.
Thanks for any help you can provide, and have a wonderful evening..!
Regards, Carlos
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Karlytos_rivas- (name?)
>
> It sounds like you have a badly designed table if each record has a
> repeating group - D1, D2, D3, etc. all related to the same description
> table.
>
> Are the "D" fields a foreign key pointing to the related record in
> descriptions? If so, you'll need multiple copies of the descriptions
> table in your query, one for each "D" field. Link the first one to D1,
> the second to D2, and so on, then grab the descriptions from the separate
> tables.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: Crystal Long <strive4peace2008@...>
> Reply-To: <MS_Access_Professionals@yahoogroups.com>
> Date: Sunday, November 25, 2012 5:49 AM
> To: "MS_Access_Professionals@yahoogroups.com"
> <MS_Access_Professionals@yahoogroups.com>
> Subject: 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@...>
> 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]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar