Access Filter Issue

[lamaar]

I have a list of products in a table. I wish to display only the top 20 of the list, or maybe enter a number.

what would be the best way to do this?

thanks

Lamaar75@hotmail.com

 

[woja]

How do you want to do this: in a query?

When you sat "top 20" how would this be determined (e.g., by sales, value, price, etc.)?

[tt]________________________________________________________________
Roger
Life is a game of cards in which the deck contains only jokers.[/tt]

 

[MakeItSo]

If the record source of your form is the table directly,
you could try
Me.Recordsource="Select TOP 20 From table"
Me.Requery

You can extend this by having a combo box with values 10, 20, ...
and then
Me.Recordsource="Select TOP " & combo & " From table"
Me.Requery

If the recordsource is a Query, then you could use, that the query must start with "Select" (6 chars).

Then you could define a QueryDef variable, set it to your query and alter the query like this:
Dim qdf as Querydef
...
qdf.SQL="SELECT TOP " & combo & Mid(qdf.SQL,7)
...

Hope this helps,
MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[MakeItSo]

Sorry,

forgot: you have to specify TOP 20 of what, of course.
(SELECT TOP 20 ID From... or similar)

 

[lamaar]

Hi guys,

thanks for responding.

I would run it in a qury and then run reports of the query

if possible, i would like to have the opportunity to enter a number and it gives me the top #, according to the number. it would basically look at a number field which would have been calculated previously.

regards

Lamaar75@hotmail.com