Hi, I have a programmer who is working on my amember database. As I have sensitive information in there, I only want to present say the last month of transactions, and customers. I've copied amember to a different database, but I'm not sure which rows to delete, and how exactly to do it. Something like this allows me to keep just the last month, but I also need to delete users, etc...not really sure if this is the way to go about it: Code: SELECT * FROM `amember_payments` WHERE `tm_added` < DATE_SUB(NOW(), INTERVAL 1 MONTH); It's true, that even from looking at one months history the programmer will have a good idea of my business takings....so I would like to remove random sales for the last month...so instead of having 10 sales a day, reduce it to 5 sales a day. so if someone has some suggestions on that...that would be great. Cheers, Ronnie