MS Access query returns 60 records I wish to change so it returns only 15 results at a time.

[47redlands]

I am using MS Access. I have created a MS Access query.
The query returned about 60 records
I want to only examine about 15 results at a time.
How can I change my query to do?

Thank you in advance

 

[PHV]

Use the TOP predicate:
SELECT TOP 15 ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

hi,

I want to only examine [highlight]about 15[/highlight] results at a time.

How would you quantify [highlight]that[/highlight] as a programmer?

How far away from 15 can that be, according to your specification? It would certainly need to be an integer number of rows, one or more. Would that be an equal number of rows plus or minus? Do you want this value about 15 randomly generated, or do you have some other algorithm in mind?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[TheAceMan1]

How are ya 47redlands . . .

If the query has a [blue]sort order[/blue] something like

[blue]Select TOP 15 ...
WHERE [sortfieldname]>[purple][b]somenumber[/b][/purple][/blue]

[purple]somenumber[/purple] has to be writen into the where clause but at least it allows for tracking.

[blue]Your Thoughts? . . .[/blue]

See Ya . . .

Be sure to see FAQ219-2884 Worthy Reading!
Also FAQ181-2886 Worthy Reading!