Microsoft Access conditional format if a value is "x" and greater than 6 months

Navigation
0

I have a database in Access , there are records that are in "Pending" value and have a date longer than 6 months so I want to make the date field turn red If the condition is as follows:

If the "Status = Pending" field and the date is > Six Months then paint the background of the date field in red color.

Until now this formula is something similar but it does not work since it colors any date equally

DateAdd("m",-6, Date())

Thank you in advance to the community for your help.

    
asked by Christ SC 22.12.2016 в 04:36
source

1 answer

0

The expression has a syntax error. In Microsoft Access, the names of the fields are enclosed in brackets, so instead of 

AgregFecha("m",-6,Fecha())

should have been written 

AgregFecha("m",-6,[Fecha])

    
answered by 25.03.2017 в 15:00
spaces between several items in one view. MVC How can I use Space (Spacebar) in the "CHOICE" command