Display data of top x %

[Faisal Mobin]

I have made query mention name of patient and balance .I have made it to display the record in ascending order the thing which i am in stuck is that how to display the result of only top 25 % from the total sales figures
Current query "
SELECT [Patient Financial Info].[Patient ID], [Patient Financial Info].[Previous Balance]


FROM [Patient Financial Info]
ORDER BY [Patient Financial Info].[Previous Balance] DESC;

[June7]

See if these help:
http://office.microsoft.com/en-us/ac...010096437.aspx
http://allenbrowne.com/subquery-01.html