I have this same problem from a db that I inherited. I'm going to have to rebuild the table that holds the "D" fields and figure out how to make a unique identifier to get to the description.
John F
--- 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 (4) |
Tidak ada komentar:
Posting Komentar