Hey guys,

I'm not quite sure about how I'd go about this with a SQL statement, so I thought I'd ask and see if I can come up with a better way.

I'll need to do some tricky reporting with dates, which will require a bit of fancy SQL to get the data I need. Basically, I've got the table set up for something "recurring" weekly, monthly, six-monthly and yearly. These are all stored as Yes/No fields. I've also got a Date field showing the day the data was entered.

What I need to do is write the SQL so that if Weekly recurrance is set, it will grab all the records that were, say, entered on a Thursday, monthly so that all the records that were entered on, say, the 3rd were grabbed, and so on and so on.

What would I need to do with SQL to get this working?