Not displaying all results in query

[darkmage1]

I have a field in one of my tables named VideoFrmt and I have 60 records with an entry of NTSC in this field. When I run a query it only displays the 20 results of the 60 entries. How do I get the query to display all the results so I would have a total of 60 records displaying NTSC?

 

[ZmrAbdulla]

Either your query will be having a clause of
"SELECT TOP 25 ...."
or a leading space in 40 entries LIKE " NTSC" that should be "NTSC".


________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[PHV]

Study the result of this query:
SELECT VideoFrmt, Count(*)
FROM yourTable
GROUP BY VideoFrmt

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