Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Top 3 from numerous different classes
Hi Mich2Too. For the source of Top 3 predicate, go to MS-Access Help. But I guess it would not enough information. If you illustrate an example, I can recognize your problem more precisely. Especially I am unable to understand the word 'class'. Of course I know that there are F-I, ... classes...- KwangShin
- Post #5
- Forum: Microsoft: Access Reports
-
Top 3 from numerous different classes
Hi, If you are looking a SQL on MS-Access, he provides a simple statement as follows. SELECT Top 3 rate from Sales_history order by rate desc; When you want to get Top 1 to 10, Regards.- KwangShin
- Post #3
- Forum: Microsoft: Access Reports
-
How to insert Subtotal into Excel File ?
This morning I received a request from my team members regarding 'Report saving into Excel format'. When she exported the report on preview, the subtotal line was not inserted into Excel file. DO you know how to handle the subtotal line of report to insert it into excel file using EXPORT...- KwangShin
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
