newbie question

[K90267000 via AccessMonster.com]

I have a table:

Field_1 Field_2
John apple
John pear
Peter apple
Jack grapes
Jack apple

Is there a way I can query, or display them in Forms or Reports like this :

Field_1 Field_2 Field_3
John apple pear
Peter apple
Jack grapes apple


OR:

Field_1 Field_2 (multivalued)
John apple,pear
Peter apple
Jack grapes, apple

Any help will be appreciated, thanks.

 

[Keith Wilby]

I have a table:

Field_1 Field_2
John apple
John pear
Peter apple
Jack grapes
Jack apple

Is there a way I can query, or display them in Forms or Reports like this
:

Field_1 Field_2 Field_3
John apple pear
Peter apple
Jack grapes apple


OR:

Field_1 Field_2 (multivalued)
John apple,pear
Peter apple
Jack grapes, apple

Any help will be appreciated, thanks.

What you have there is a one-to-many relationship between the person and how
many types of fruit they have an interest in, so you need to have two
tables, tlbPerson and tblFruit, and set the relationship up between them.
This is called "normalization". Search the help for "about table
relationships" for more info.

HTH - Keith.
www.keithwilby.com

 

[scubadiver]

Make "NameID" a number (long integer)

tbleName
NameID (PK)
Name

tbleFruit
NameID (FK)
Fruit

Go into the relationship view (tools menu).

Show the two tables and drag "NameID" from tbleName to tbleFruit then
establish integrity and create the relationship.

When you open "tbleName" each row will have a "+" sign. Click on it and it
will show all the related rows in "tblefruit" for that name.


--
http://www.patriotsquestion911.com
http://www.911truth.org
http://www.wtc7.net
http://www.st911.org
http://www.journalof911studies.com
http://www.pilotsfor911truth.org
http://ae911truth.org

 

[John Spencer]

Quoting Duane Hookom

For your second solution I use a generic Concatenate() function.
See:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..