Solved

Cross tabulation querry

Posted on 2013-11-04
4
238 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
  • 2
4 Comments
 
LVL 62

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 62

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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now