Question about Group Header and Footer

[demoman]

Hi

I have created a report which has a 2 level ascending sort. There is no detail section, just a group footer. A simplified view of the data is:

BoxID LocationID DateSet
1234 1 11/01/01
1234 2 11/10/01
1234 3 11/15/01

Now, what I want to print is:

BoxID LocationID DateSet
1234 3 11/15/01

So, I created a control break for BoxID, sorted the report by BoxID,DateSet, located the fields on the BoxID footer line. I would expect to see the data values from the LAST row, (I have worked with many other report writers, and they worked this way). Instead, I get the values from the FIRST row.

Troubleshooting the problem, I created a BoxId header section and copied the fields there too. Both header and footer show the same data?

What I would like to know; is this the normal behavior for Access? Also, I would appreciate suggestion on how to achieve my desired format.

Thanks

 

[Lozere]

YES Access begin with the first record (row).

The quickest way is to supply data to your report through a Query with the Operation parameters set to Last for each of you 3 fields.
So the query does only contains the last row and the report has no choice but to print it!