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


Item   |    Day1   |   Day2       Day3      Day4
.....      |      n       |
.....      |      n       |
Anthony MatovuBusiness Analyst, MTN UgandaAsked:
Who is Participating?
CodeCruiserConnect With a Mentor Commented:
See if following article from MS helps. It has step by step instructions on creating the cross tab query
Fernando SotoRetiredCommented:
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, ...
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

Fernando SotoRetiredCommented:
Hi Anthony;

Sorry but I am not familiar enough with Microsoft Access SQL commands to be of any help with this question.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.