Thread: Limiting Query Results?

Hello,

I have 2 SELECT queries made in MS ACCESS.

The first one counts the number of tickets based on availability and showName.

Code:

"SELECT Count(1) AS TicketCount FROM shows INNER JOIN performances ON shows.showID = performances.showID WHERE performances.status="Available" AND shows.showName = "Spooks""

The 2nd query displays the performanceIDs for the shows that are available.

Code:

SELECT shows.showName, performances.performanceID FROM shows INNER JOIN performances ON shows.showID = performances.showID WHERE shows.showName="Spooks" AND performances.status="Available""

basically 1st one counts

and the 2nd one is just a normal query.

I want to limit the results for the 2nd query to what the user requests. IE. if they select 5 in the previous page i want the query to only return 5 records.

any ideas?

I found out that by adding 'TOP' it limits the results to what ever number i place it.

But how do i define the number based on

Code:

SELECT TOP 5 showName FROM shows WHERE status = "available"

But the "5" needs to be defined by the user, and it could be any number they select in the combo box in the form

any ideas?

Originally Posted by mehere

is this in an ASP Form or an Access form?

ASP form

Originally Posted by richyrich

I'm assuming here that by combo box, you mean a <select> element without multiple selections?

urrrm? yes... i think so