Rank Function

[Rajivalwar]

Hi

Try this:

SELECT 
	*
FROM

	(

		SELECT 
			*, 
			DCOUNT("OrderID","SalesTable","(Month = '" & Month &"' AND Sales > " & Sales &")") As Rnk 
		FROM 
			SalesTable
		ORDER BY
			Month,
			Sales DESC

	)
WHERE
	Rnk>10