Top 25 Cost Report-PLEASE HELP

  • Thread starter TOP 25 REPORT And 26th line all others
  • Start date
T

TOP 25 REPORT And 26th line all others

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.
 
A

Arvin Meyer

"TOP 25 REPORT And 26th line all others" <TOP 25 REPORT And 26th line all
[email protected]> 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.
Click to expand...

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
 
J

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.
Click to expand...

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]
 
Top