Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / March 2007

Tip: Looking for answers? Try searching our database.

Value in Crosstab Query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
hongluen - 22 Mar 2007 04:31 GMT
Can I show all the data or merge them into one single cell,
instead of doing any aggregate functions such as sum and average,
in a Crosstab Query?

To illustrate my question:
StudentID          TestID          Score (Date)
AAA                     1                50 (date1)
AAA                     1                60 (date2)
AAA                     1                55 (date3)
AAA                     2                23 (date2)
AAA                     2                24 (date4)
AAA                     3                98 (date4)

I want to show the data in a Query or Report in this way:
StudentID           Test1            Test2              Test3
AAA                50 (date1)      23 (date2)      98 (date4)
                      60 (date2)      24 (date4)
                      55 (date3)

I worked out a Crosstab Query, but it allows to show only the First or the
Last record.
Duane Hookom - 22 Mar 2007 06:15 GMT
You can use the generic concatenate function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane as the
value.
Signature

Duane Hookom
Microsoft Access MVP

> Can I show all the data or merge them into one single cell,
> instead of doing any aggregate functions such as sum and average,
[quoted text clipped - 17 lines]
> I worked out a Crosstab Query, but it allows to show only the First or the
> Last record.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.