Advertisement

05.05.2004 at 10:02AM PDT, ID: 20979029
[x]
Attachment Details

Crosstab query

Asked by xhenkaii in Microsoft Access Database

Tags: , ,

Hi guys,

can a crosstab query that can group results  in a range of parameters in its column headings?example the range of 4-15 mins there is a delay.It's hard to explain in words below is the design of the crosstab i wanted,like to check with u all can it be done in this way?(wanted to keep track of the range) Thanks!


Delay Code   4-15 mins    16 - 20 mins      Total
        AC         1                     1                  2
        AX                                1                  1
        AZ         1                                         1
                Start Free Trial
[+][-]05.05.2004 at 10:08AM PDT, ID: 10997938

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Tags: crosstab, query, range
Sign Up Now!
Solution Provided By: gmsullivan
Participating Experts: 1
Solution Grade: A
 
 
[+][-]09.05.2004 at 12:53PM PDT, ID: 11985443

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]09.09.2004 at 03:32PM PDT, ID: 12022194

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32