Solved

Cross tabulation querry

Posted on 2013-11-04
4
245 Views
Last Modified: 2013-11-15
Dear All

I have a list of items sold at different days.

I would want to have a report like below where n is the number of items sold on a day

I am thinking i can have this in a single query

This is where i seeking your help

I am using VB.NET

Anthony

------------------------------------------------------------------
Item   |    Day1   |   Day2       Day3      Day4
.....      |      n       |
.....      |      n       |
------------------------------------------------------------------
Total
-----------------------------------------------------------------
0
Comment
Question by:Anthony Matovu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 63

Expert Comment

by:Fernando Soto
ID: 39621511
Hi MatovuAnthony;

It would help to know what the data source is such as SQL server, List of .Net Objects and what columns / properties are available. How do you determine Day1, Day2, ...
0
 
LVL 1

Author Comment

by:Anthony Matovu
ID: 39621537
It is ms-access database,
day1,day2 are the days of sale
in the row i would want to put items sold (shirts, trousers) etc

For exmple n in day1 would say number of shirts sold on day1.

I am getting the data from access using VB.NET and would want to display on a spread


Thank you

Anthony
0
 
LVL 63

Expert Comment

by:Fernando Soto
ID: 39621792
Hi Anthony;

Sorry but I am not familiar enough with Microsoft Access SQL commands to be of any help with this question.
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 39621937
See if following article from MS helps. It has step by step instructions on creating the cross tab query

http://office.microsoft.com/en-gb/access-help/make-summary-data-easier-to-read-by-using-a-crosstab-query-HA010229577.aspx
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

705 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