I was going to suggest a simple summary report until I got to this line:
"I just need the output to be in a plain copy and pasteable format."
You don't need that capability to be able to print out such a report, why do you need that capability?
The output is not going to be printed. I'm going to be pasting the output into a file for use online so it needs to be copy and paste friendly somehow. It also needs to be just as stripped down and simple looking as in my example seeing as it'll be a relatively sizable list to be scrolling through. (Not so big though that it'll be much of a strain to process.)
Ok, create a new blank layout based on your cards table and go into layout mode.
Double click the body parts part label (grey rectangle that reads "body')
Change your body part to a sub summary when sorted by condition part.
Place your Name, Condition and price fields in this part.
Add a new summary field, sCardCount and define it as the "count of" of one of your other fields such as name.
Place this field in your layout to show the number of cards in each type.
Sort your records by name and then by condition and you'll have the listing you need.
To copy and paste this report, export it as a tab delimitted text file or as an excel spreadsheet and select your condition field as the "group by" field when exporting this data.
You can then copy and paste your text from this exported file.
Thank you, that set's it up exactly how I wanted.