My company wants to send out Christmas cards, to the top Customers (based on total sales).  I know how to make a report that shows each individual invoice and then subtotals each customer's total sales, but I don't know how to make a report that just lists the customer's code, name, and total.

The elements I'm working with are Code, Customer, Invoice Total, and the generated Subtotal.  I break on Code.  What I'm hoping for is a report that shows a single line for each customer, showing his code, name, and total total.  I do not use subpages in my form.

Can this be done?  I'm sure it can be done, but I'm not sure how to proceed.

What I've done so far (for our Crane customers) is to copy the report from the browser and paste it into Excel as Text.  I then move the total for each customer to one of his individual invoice lines, into a new column.  When that's done, after scanning around 4000 lines and moving the generated total data for about 700 customers, I sort on that column, descending.  That drops all the individual lines below the ones I've put the new column data into, and I can delete those lines.  Needless to say, this is a real pain.

Any advice or suggestions would be appreciated.  Thanks!

While Erica is doing that for you, why don't you consider adding a few fields to the Customer database?

Add Last Transaction Date, Last Invoice, MTD and YTD fields.  Then when you create invoices you can post vlaues to the Customers' records that show the MTD, YTD totals, the last Invoice and the last transaction date.   You will also need to post credits.  You could also add a filed for Previous YTD.

You can run a Mass Update that the start of each month and each year to clear the MTD,, YTD and Previous YTD fields.  Now you will have simple fields you can use in Retrieve Specs and on reports without having to cycle through all records and sub records for each customer.

This suggestion sounds familiar to me, did I already suggest this to you a few years ago?

Erika, that's marvelous, thank you muchly.  Works great!

Bob, thanks for the ideas but that's a level of detail I really don't need.  This report will only run once a year (by me, anyway.  The boss may like to run it occasionally, once he finds it.)