Solved

Cross tabulation querry

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

772 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