PC Review


Reply
Thread Tools Rate Thread

Displaying multivalue field data in report

 
 
Ken Warthen
Guest
Posts: n/a
 
      11th Apr 2010
I have an Access 2007 database that was built upon the Access Contacts
template. A multivalue field called Tags was added to the Contacts table
that may have any or all values available in a table called Attributes. I
have some sample data of contacts where the tag field for a record may
contain a single tag like smart, or several values like smart, tall,
agressive. When I try to display the tag values for each record in a report
the displayed value is numeric like 2, 4, 7. How can I get the report to
show the actual values instead of what appears to be an index value for each
tag value?

Ken
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieving data from a multivalue field in SharePoint to Access NGP Microsoft Access External Data 1 12th Sep 2009 05:05 AM
MultiValue Field Scott Microsoft Access Database Table Design 8 17th Apr 2009 09:02 PM
Problems with Multivalue Field Brian Carlson Microsoft Access Getting Started 3 12th Feb 2009 05:08 PM
SharePoint MultiValue Field Data Extraction and UNION Query Mike Hill Microsoft Access Queries 2 2nd May 2008 02:13 PM
Multivalue Field list in Report dtjbocala Microsoft Access 2 7th Mar 2008 10:19 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:48 PM.