Next, we'll create a second query that displays all the data you need to see and base a subreport on that. Then, we'll base a report on the Totals query. You could spend a lot of time writing the perfect SQL query, but the Report object offers a simpler route that users, without the benefit of specialized knowledge, can implement.įirst, we'll create a Totals query comprised of only the grouping field. Fortunately, Access is definitely up to the challenge. Grouping records in Access is easy, but limiting each group to a specific number of records isn't.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |