Prev: Office 2003 OEM
Next: hellow
From: Angela on 2 Apr 2010 01:17
Hi,

I have a below list of numbers.

566667
566668
566669
566665
566666
566671
566672
566680


I want a query that would return a count between start and end of
range.

Like

Start End Quantity
566665 566669 5

566671 566672 2

566680 566680 1


Thank you.
From: XPS350 on 2 Apr 2010 02:22
On 2 apr, 07:17, Angela <ims...(a)gmail.com> wrote:
> Hi,
>
> I have a below list of numbers.
>
> 566667
> 566668
> 566669
> 566665
> 566666
> 566671
> 566672
> 566680
>
> I want a query that would return a count between start and end of
> range.
>
> Like
>
> Start        End         Quantity
> 566665     566669     5
>
> 566671      566672     2
>
> 566680       566680     1
>
> Thank you.

A query to do this could look like:

SELECT Count(YourNumber) AS CountOfNumbers
FROM YourTable
WHERE YourNumber>=[Enter Start] And YourNumber<=[Enter End];

Groeten,

Peter
http://access.xps350.com
From: Risse on 2 Apr 2010 02:53

"Angela" <imsguy(a)gmail.com> kirjoitti
viestiss�:1acfa36e-8d83-455f-8e9b-9b561c95fdd4(a)10g2000yqq.googlegroups.com...
> Hi,
>
> I have a below list of numbers.
>
> 566667
> 566668
> 566669
> 566665
> 566666
> 566671
> 566672
> 566680
>
>
> I want a query that would return a count between start and end of
> range.
>
> Like
>
> Start End Quantity
> 566665 566669 5
>
> 566671 566672 2
>
> 566680 566680 1
>
>
> Thank you.


From: Angela on 25 Apr 2010 04:39
Hey John,

Your query approach is good but I'm still checking it with the text
field output.

Will get back to you on this one.
 | 
Pages: 1
Prev: Office 2003 OEM
Next: hellow