Hello-<BR><BR>I'm trying to generate a report of the total spending for a customer over the past 12 months. I have all of the data in the database, and can manipulate it for any given month. How would I write a script that goes through the data and spits out an array filled with the total spent for the previous 12 months. (Notice I don't want all of the data for the current year, but rather the previous 12 months.) All of the date fields in my database are stored as (xx/xx/xxxx). So somehow I need to run a loop with a query inside it that only receives data for a particular month? Is there an easy way to do this? Am I making any sense?