Recent content by Reno911

Got the new record source to work. Thanks again

Got it to work using the Record Source shown above, however, still see the random Conditional Formatting issue as before (maybe slightly less random. Now, only the first record doesn't format). Thanks for teaching me something new! It's ok, I can live with it as-is. Thank you for your assistance.

Thanks for your reply. I made those changes and find the results are still random....the only exception being the first record (Battle Mountain CSS) is now always not Conditionally Formatted (i.e. not turning red). That's something different. As with before, everytime I open and close the report...

Thanks for your reply. I know, off to a slow start here. I should point out, the records are displayed in the Footer (see attached). Otherwise, if it was just in the Detail section, the DMax was not working.

I have a Report “SITE_VISITS” with a Text Box, “Text15”, formatted as a Short Date, that uses Conditional Formatting to turn Red when “TA_START_DATE” occurred 180 day ago. “TA_SITE_VISITS” Query is the Record Source for the Report. Text 15 displays the most recent date for the site visit by...