• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

Cross tabulation querry

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
Anthony Matovu
Asked:
Anthony Matovu
  • 2
1 Solution
 
Fernando SotoCommented:
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
 
Anthony MatovuBusiness Analyst, MTN UgandaAuthor Commented:
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
 
Fernando SotoCommented:
Hi Anthony;

Sorry but I am not familiar enough with Microsoft Access SQL commands to be of any help with this question.
0
 
CodeCruiserCommented:
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now