Top x records

[PortyAL]

I have a query in a database which returns the top 50 records in a table, with the "50" being set in design view. However, I do not always want the top 50 - sometimes I need more, sometimes less. Is it possible to program the query so that when you run it, it asks you how many records you want displayed?

Thanks

AL

 

[BNPMike]

I think you need to copy the query into a VBA module, pick up the variable element from a form and run the dynamically built SQL from VBA.

 

[Crowley16]

or you could try to modify the querydef's .sql property to re-edit the sql string before running it...

--------------------
Procrastinate Now!

 

[PHV]

This topic has been covered recently.
Do a Search in this forum for top parameter

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886