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
471 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
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 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now