Evening all. I am creating a school sports fixture's system on Microsoft Access 2003.

One of the end user requirements were "Flag up unconfirmed fixtures".

Now, unconfirmed fixture means fixtures that were arranged before the term started but must be confirmed at least 7 days before the games takes place.

I've racked my brains for this answer, done plenty of research on the internet, read books etc. but haven't got the answer!

My question: How do I get unconfirmed fixtures that are to be played within 10 days to be flagged up in red when the application is opened?

Is there an SQL code I could use or some sort of trigger I can create in Access itself?

If you have any questions please ask!

Thanks Rushy