Solved

Cross tabulation querry

Posted on 2013-11-04
4
239 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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…
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 …

911 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

24 Experts available now in Live!

Get 1:1 Help Now