restrict the number of recordset results 1

[FesterSXS]

Simple one I'm sure but I've never actually used it so have no idea of the SQL syntax.

just need to limit the number of returned results from a SQL query

cheers in advance

Tony

http://www.phoenix-paints.co.uk/portfolio

 

[JuanitaC]

SELECT Top 10* FROM tblTest order by colName ASC

will give you the first 10 records from the tblTest. Is this the syntax you are looking for?

 

[FesterSXS]

I'll let you know - what is the * for? Tony

http://www.phoenix-paints.co.uk/portfolio

 

[FesterSXS]

forget it - all fields, right?? Tony

http://www.phoenix-paints.co.uk/portfolio

 

[JuanitaC]

That is just to select all fields from the table. You could also name the column:

SELECT Top 10 ID, Name, Address FROM tblTest

 

[FesterSXS]

just what I needed - thanks Tony

http://www.phoenix-paints.co.uk/portfolio