Re: I need a query

From: Mehran (anonymous_at_discussions.microsoft.com)
Date: 03/13/04 

Date: Sat, 13 Mar 2004 01:32:42 -0800

Hi!

Thank you for your reply.
It doesnīt matter. The query is

SELECT * FROM MONEY

When i run this query i get 100 rows. But i want to see
rows between 20 and 40. I can see top 20. Itīs easy

SELECT TOP 20 FROM MONEY

But my question is, is it possible to run a query to get
row between 20 and 40 or 40 and 60 etc.

Mybe like this

SELECT BETWEEN 20 TO 40 FROM MONEY :-)

Thank you once again for your reply
Kind regards
Mehran
>-----Original Message-----
>Can you post your query? What are you using as criteria
for the top 100?
>
>--
>Ray Higdon MCSE, MCDBA, CCNA
>---
>"Mehran" <anonymous@discussions.microsoft.com> wrote in
message
>news:c5ee01c40887$7117aa40$a101280a@phx.gbl...
>Hi!
>
>Think that you get 100 rows in result of a query. But i
>donīt want to see all of them. I want to see the rows
>between 20 and 40. Is it possible to do a query who get
>the rows between 20 and 40???
>
>Thank you for helping me
>Kind regards
>Mehran
>
>
>.
>

Relevant Pages

  • Re: Please Help with Query Calculations
    ... As for the other fields I put SUM but its not summing them up. ... of the query, go up to View and select Totals. ... maybe a few more fields) and an Sum the Amounts Owed and Amounts Paid ... is several dates of when people were billed money and paid money. ...
    (microsoft.public.access.queries)
  • Re: Doctors Income
    ... That you pose the query you do in the vague/open-ended form in a way ... Even way out here in the bowels of fly-over country, I'm often pleasantly surprised to discover the depth and breadth of info that the libraries place at my fingertips. ... Of course, every other budget cycle the libraries are targets for the politicians who want to spend the money on sexier projects, so vigilance is always necessary. ...
    (soc.retirement)
  • Re: I need a query
    ... "Mehran" wrote in message ... When i run this query i get 100 rows. ... SELECT TOP 20 FROM MONEY ... Kind regards ...
    (microsoft.public.sqlserver.mseq)
  • Re: Update Query & Expression Help
    ... AccountID integer, ... Qtr1 money, ... > I have a Query I want to run, to update a field in the MASTER table. ... > examine 4 fields each record of MASTER to find the Highest Max value; ...
    (microsoft.public.access.queries)
  • Re: My design - where did I go wrong?
    ... > money S1, ... Is it the combination of CustID and SaleDate? ... then the query will be as fast as possible. ... beyond the 4th decimal is lost in a money data type, ...
    (comp.databases.ms-sqlserver)