Jan,
Please include the significant parts of previous messages in the thread so we don't have to look back to find the context. If you are seeing some numbers mixed in with text values, your [Status or Event] is apparently being populated through different methods. One method is getting the values from some ID column while another method is grabbing the text value.
Can you provide information/records from your Status or Event lookup table?
Typically you would have a lookup table of [Status or Event] values with a numeric primary key and a text title.
Duane Hookom, MVP
MS Access
Previous Message:
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 27 Apr 2015 13:10:10 -0700
Subject: Re: [MS_AccessPros] Crosstab Query
TRANSFORM Count([Activities & Statuses for Contacts].[ID]) AS CountOfID
SELECT [Activities & Statuses for Contacts].[Contact ID]
FROM [Activities & Statuses for Contacts]
GROUP BY [Activities & Statuses for Contacts].[Contact ID]
PIVOT [Activities & Statuses for Contacts].[Status or Event];
Please include the significant parts of previous messages in the thread so we don't have to look back to find the context. If you are seeing some numbers mixed in with text values, your [Status or Event] is apparently being populated through different methods. One method is getting the values from some ID column while another method is grabbing the text value.
Can you provide information/records from your Status or Event lookup table?
Typically you would have a lookup table of [Status or Event] values with a numeric primary key and a text title.
Duane Hookom, MVP
MS Access
Previous Message:
I have created a table with six statuses and assigned to each person on my contact list. Some people have more than one status. I want to do a crosstab with ID, FirstName, LastName as rows and Status' as columns.
For some reason, it does not seem to pick up all the status names as column headings. I am getting 3, 6, Bike, Friends, etc. Any idea what would cause it to reject my status' as column headings? Thanks
| Bike |
| Friends |
| Officer |
| Tax_Sensitive |
| Trees |
| LOWV |
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 27 Apr 2015 13:10:10 -0700
Subject: Re: [MS_AccessPros] Crosstab Query
TRANSFORM Count([Activities & Statuses for Contacts].[ID]) AS CountOfID
SELECT [Activities & Statuses for Contacts].[Contact ID]
FROM [Activities & Statuses for Contacts]
GROUP BY [Activities & Statuses for Contacts].[Contact ID]
PIVOT [Activities & Statuses for Contacts].[Status or Event];
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (16) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar