Re: I need a query

From: Ray Higdon (sqlhigdon_at_nospam.yahoo.com)
Date: 03/13/04 

Date: Fri, 12 Mar 2004 21:05:55 -0500

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: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)
  • Re: using a form with combo box to input criteria
    ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)
  • RE: Complex query criteria - desperate appeal
    ... The following will search for query by form: ... > appropriate SQL string if it is not. ... > Dim qdf as DAO.QueryDef ... > criteria in text fields, you would have to modify these somewhat to give the ...
    (microsoft.public.access.queries)
  • Re: requery vs. refresh vs. Remove Filter/Sort
    ... control naming, but the JRCustNum is the form's control name that the query ... looks at in terms of criteria for the CustNum field. ... that looks up Employee ID's that belong to Order Entry Department.). ...
    (microsoft.public.access.formscoding)