Top n records

[Ulsterman2]

I have the following query which selects the top 25 records based on the
"Random" field.

SELECT TOP 25 [qry Invoices].ID, [qry Invoices].Period, [qry
Invoices].Gross, [qry Invoices].Random
FROM [qry Invoices]
ORDER BY [qry Invoices].Random;

The problem is that I do not always want the top 25. Ideally I would like
the query to ask me how many records I want to show. Is this possible?

 

[lespaul]

yes....you would have to create a dynamic SQL statement that is built when you press a button on the form where you enter the number of records you want to return.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[Ulsterman2]

Thanks. Next question...

What would the dynamic SQL be?

 

[lespaul]

something like this in the OnClick event of a button:

Dim strSQL As String
Dim db As Database
Dim rs As Recordset

Set db = CurrentDb
strSQL = "SELECT TOP " & Me.txtBoxName & " FROM TableName;"
              
Set rs = db.OpenRecordset(strSQL)

the syntax may be off some, I don't do Access programming.

HTH

leslie