Daily queries automatic?

[Mhypertext]

I have a mail list

I want to pull daily play "I have an exctraction that shows it for everyone"

I need to inner join against the mail list then dedupe it everyday against the prvious day so i only get the first day of play

will i have to do this mauanlly everday or is there a way to create a database or select statement i can cut and paste to do it all for me

 

[CraigDolphin]

You might stand a better chance of a reply if you were better able to describe exactly what data your database stores so that we have some context when you say things like "then dedupe it everyday against the prvious day so i only get the first day of play", which has absolutely no meaning to me.

Then describe what you want your daily report to contain and I suspect someone will be able to tell you how to go about achieving it. But if you don't explain the background information we're guessing in the dark and likely wasting all of our time.