arr records except last

[deb]

access 2003

In a report I need to show all records except the last one.
How can I edit the query to show all except the last one?

thanks

 

[Duane Hookom]

I would probably do this in the report by cancelling the Format of the final
detail section. Add a text box to the Report Header section:
Name: txtCountAll
Control Source: =Count(*)
Visible: No
Add a text box to the Detail Section
Name: txtRunCount
Control Source: =1
Running Sum: Over All
Visible: No
Then add code to the On Format event of the Detail Section of the report:
Cancel = Me.txtCountAll = Me.txtRunCount