StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
230823
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
2008-10-23T18:17:55.173
CreationDate
2008-10-23T18:17:55.173
FavoriteCount
0
LastActivityDate
2008-10-23T18:23:36.970
LastEditDate
2008-10-23T18:23:36.970
LastEditorUserId
7899
OwnerUserId
7899
ParentId
230241
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
To accomplish your task you will need to use code. One solution, using more meaningful names, is as follows: Main table with two applicable columns: <blockquote> Table Name: Widgets Field 1: ID (Long) Field 2: Color (Text 32) </blockquote> Add table with two columns: <blockquote> Table Name: ColorListByWidget Field 1: ID (Long) Field 2: ColorList (Text 255) </blockquote> Add the following code to a module and call as needed to update the ColorListByWidget table: <pre><code>Public Sub GenerateColorList() Dim cn As New ADODB.Connection Dim Widgets As New ADODB.Recordset Dim ColorListByWidget As New ADODB.Recordset Dim ColorList As String Set cn = CurrentProject.Connection cn.Execute "DELETE * FROM ColorListByWidget" cn.Execute "INSERT INTO ColorListByWidget (ID) SELECT ID FROM Widgets GROUP BY ID" With ColorListByWidget .Open "ColorListByWidget", cn, adOpenForwardOnly, adLockOptimistic, adCmdTable If Not (.BOF And .EOF) Then .MoveFirst Do Until .EOF Widgets.Open "SELECT Color FROM Widgets WHERE ID = " & .Fields("ID"), cn If Not (.BOF And .EOF) Then Widgets.MoveFirst ColorList = "" Do Until Widgets.EOF ColorList = ColorList & Widgets.Fields("Color").Value & ", " Widgets.MoveNext Loop End If .Fields("ColorList") = Left$(ColorList, Len(ColorList) - 2) .MoveNext Widgets.Close Loop End If End With End Sub </code></pre> The ColorListByWidget Table now contains your desired information. Be careful that the list (colors in this example) does not exceed 255 characters.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PODoes MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USpro3carp3
UserOwnerUserId
1. USpro3carp3
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.