Top 25 Cost Report-PLEASE HELP

[Guest]

I'm trying to figure out how to do an access report like Crystal top 25 with
all other parts without going through so many steps. I want top 25 and then
a total for all other parts at the last row at the bottom, where it does it
automatically.

 

[Arvin Meyer]

"TOP 25 REPORT And 26th line all others" <TOP 25 REPORT And 26th line all
(e-mail address removed)> wrote in message

I'm trying to figure out how to do an access report like Crystal top 25 with
all other parts without going through so many steps. I want top 25 and then
a total for all other parts at the last row at the bottom, where it does it
automatically.

Just use the TOP keyword:

SELECT TOP 25 Whatever, DateUpdated
FROM MyTable
ORDER BY MyTable.DateUpdated DESC;

That will give you the 25 latest records.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[John Vinson]

On Mon, 17 Jan 2005 11:41:03 -0800, "TOP 25 REPORT And 26th line all
others" <TOP 25 REPORT And 26th line all

I'm trying to figure out how to do an access report like Crystal top 25 with
all other parts without going through so many steps. I want top 25 and then
a total for all other parts at the last row at the bottom, where it does it
automatically.

Base a Report on a Query with the Top Values property set to 25; do
the totals in the Report footer.

Access is not a flawed implementation of Crystal Reports. It is a
different program, with its own conventions and its own programming
style. Try working with it instead of struggling to jam it into the
mold of some other program!

John W. Vinson[MVP]