is it possible to limit a MS Access Report to the first 3 rows if the table contains more than 3 rows?

Question

The table has 100 + rows but I only want to display the top 3 in a report. Would prefer not to use SQL commands to do this.

Answer 1

Create the report to display the information three times, with a "next record" at the end of the first two line. Do not place a "next record" after the last line and it will not display any more records.

Answer 2

You're going to have to use some sort of command, whether it be a bit of simple SQL or a nightmarish piece of VBA.

Also, the "top 3" is a bit of an imaginary idea - you can sort a table by a different field and instantly alter what "top 3" actually means. I would say that you need to define to yourself more clearly what you mean by "top 3", and write an SQL statement to only select those three.

Rawlyn.

Answer 3

yeah easy - if the report is based on a query, you can edit the query and use the drop down at the top which says "All". Change this to a number, and that is all that will be returned.
If you look at the SQL behind this, it says "select top n" where n is the number you chose, so you could also write it into any code if you're doing it that way.

Answer 4

certain. each and every so often get admission to each and every so often guesses Excel files kinds incorrect. once you've issues on your queries, (a)create an section db with maximum excellent files kinds and populate it from the spreadsheet, or (b) save the sheet in textual content (.csv) format and link it - you could create, save and use the import files style definition.

Answer 5

Joe Willy Neckbone says, "I don't rightly know the answer to your question, but I will be right here waiting for you to ask a question that I do know the answer to."