Prev: underscore sign in query
Next: iif statement what is wrong with this expression
From: deb on 23 Mar 2010 12:54
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

--
deb
From: Duane Hookom on 23 Mar 2010 12:59
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

--
Duane Hookom
Microsoft Access MVP


"deb" wrote:

> 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
>
> --
> deb
 | 
Pages: 1
Prev: underscore sign in query
Next: iif statement what is wrong with this expression