?
Solved

If I open an internal Access 2003 table that has a field with multiple values, how would I open this field to see all of the values within it?

Posted on 2013-12-26
3
Medium Priority
?
486 Views
Last Modified: 2013-12-26
I use Access 2003.

If I open an internal Access 2003 table that has a field with multiple values,
how would I open this field to see all of the values within it?

If I expand the Row Height, I see additional values within the same row.
0
Comment
Question by:zimmer9
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 28

Expert Comment

by:omgang
ID: 39740346
I'm pretty sure MS Access 2003 doesn't have multi-valued fields.  Please provide a screen shot of what you're seeing.
OM Gang
0
 

Author Comment

by:zimmer9
ID: 39740371
The CC field has values shown in the following snaphot for 1 record:
CC.doc
0
 
LVL 48

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 39740406
That appears to be a string value, probably with carriage return/line feed characters embedded in the string.

If you type:

?DLOOKUP("CC", "tblRptCover", "rptID = 1")

in the immediate window, what gets printed out?
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question