Conditionaly Highlight an Expiry Date in a Form that is Due in 40 Days

[cokenorris]

How can I set the above, and create a report for all dates in a database that are due in 40 days?

[twinnyfo]

What have you tried so far? Exactly what is it that you are looking for, because it looks like you are asking for two different things: One is a report for dates meeting that criterion, the other is conditionally formatting a date.

It is confusing as to exactly which you are asking for.

[NeoPa]

Start by adding a calculated field into your query such as :

(DateAdd('d',40,Date())>[DueDate]) AS [NearlyDue]

Using Conditional Formatting is a matter of selecting it from the menu or ribbon and configuring it. You can use [NearlyDue] in your criteria.