Question: I am currently working on a system that's based around the concept of Digg where you have a button on an external site and a user who clicks that button gets to post / digg it.

Anyway, I'm looking for some information on the types of spam that I should expect as time goes on.

So far I have thought about a fair few factors, such as flag system, X rates by different users before frontage, Domain Monitoring, and some others.

Any ideas on what money-hungry site owners would attempt?

Answer: 
There is no point in sorting in the SQL or query on which the report is based. The report uses its own sorting and grouping which you will find on the ribbon (Access 2010) in design view for the report: Group & Sort.

The record source can be found on the property sheet for the report.
From the report's design view, view the report's properties (I right-click on the box in the upper left corner under the window's title bar.)

Then you can modify the report's recordSource property.

You'll also want to look at the way the report is grouped and sorted. I'm pretty sure it's under the View menu, but they've uninstalled 2007 as of yesterday out here, so I'm still finding where stuff is in 2010.

HTH