Requesting the amount of records to be returned

[Uvuriel03]

Alright, first off, I'm not even sure this is possible.

I'm working with Access 2007, too.

I have a report that is based off of a very simple query that requests a part number. I know you can select a particular amount of records to be returned in a query (All, 5, 25, 100, 5%, 25%).

What I'm wondering is this: Can you use SQL or something else to actually have the query REQUEST the number of records to be returned, rather than have it pre-determined? The reasoning behind this is that we use a query to create a pull-sheet for particular items that need to be shipped out.

The pull sheet as it is right now prints all of each item and their locations, but we don't usually need ALL of the items. Is there any way to enter a parameter to request how many of each part are needed?

 

[georgedwilkinson]

Yes.

select top 5

You have that in your options, did it not work?

 

[Uvuriel03]

I realize that you can SET the number it pulls. What I'm wondering is whether you can have the user enter the number as a parameter. As in, when you run the query, it would say something like;

Parameter:
What part? _____________

Parameter:
How many? _____________

And then it would return however many records the user requested, rather than whatever is defined in the query.

 

[georgedwilkinson]

Not as a parameter. I'd think you'd have to build dynamic SQL to do that.