Using Select Top 20 statement doesn't always produce top 20! I have it on several reports and sometimes it's 20 sometimes 21, sometimes 25 (never the whole table though!). Any thoughts? Thank you


SELECT TOP 20 [TBL:BATCHES].DATE, [TBL:BATCHES].[ITEM KEY], [TBL:BATCHES].[FORMULA KEY], [TBL:BATCHES].[FORMULA REVISION NUMBER], [TBL:BATCHES].[BATCH NUMBER], 0.98 AS [TS MIN], 1.02 AS [TS MAX], [TBL:BATCHES].[TINT STR INITIAL], [TBL:BATCHES].[TINT STR FINAL]
FROM [TBL:BATCHES]
WHERE ((([TBL:BATCHES].[ITEM KEY]) Like [forms]![formGraphDates]![cboProduct]) AND (([TBL:BATCHES].[TINT STR FINAL]) Is Not Null))
ORDER BY [TBL:BATCHES].DATE DESC;