Good morning,
I am new to Access and I'm having trouble getting my rows of an Access 2007 report to conditionally format how I want them to. Here's the situation:
I have a report that has about 12 columns of data, one of them being a next deadline field, titled "NEXT DEADLINE".
I have already formatted the specific "NEXT DEADLINE" field to highlight red if the deadline is within 30 days from a certain date, which works fine. However, when I try to conditionally format the other columns, such as "CUSTOMER NAME" in the report to highlight red based on the date in the NEXT DEADLINE field being within a certain range, such as within 30 days, nothing happens.
I have looked online and found suggestions of expressions to try such as [NEXT DEADLINE]<30, Eval([NEXT DEADLINE] Between "3/25/2015" And "4/25/2015"), and other combinations of these conditions, and none of them seem to work.
Does anyone have any advice or possible solutions? Any advice is greatly appreciated.