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

Minggu, 25 November 2012

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

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@yahoo.com>
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@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]

------------------------------------

Yahoo! Groups Links