comparing dates and other stuff...

[BubBob]

I have a "search form", which has a field with following row source:

(SELECT DISTINCTROW Main.OrderID, Main.SFPOrderID, Companies.Fullname, Main.Date, Main.RDate, Main.SDate, Main.Finished FROM Companies INNER JOIN Main ON Companies.CustomerID = Main.CustomerID

I'm trying to find all records where RDate will be less than 7 days from now. Easy to do with DateDiff, but how can i somehow mark all those rows in the field, for example make them red! Cannot find a way. Or simply display all those records, that would be good enough.

 

[Mile-O]

I'm trying to find all records where RDate will be less than 7 days from now. Easy to do with DateDiff

DateDiff? That complicates it more than using the simple criteria:

>=DateAdd("d", -7, Date())

You can set the SQL to be the RowSource of a ListBox and therefore display them.