Question
August 24, 2007 at 06:19 AM
thomas.hartsfield

MS Access Expressions

by thomas.hartsfield . Updated 19 years, 2 months ago

I’ve created an Access database to track projects and would like it to compare the current date to the due date. If the Due Date is equal to the current date, I want it to print, “DUE TODAY” on the report. If the current date is older than the due date, I want it to print “OVER DUE” on the report. I have not been able to figure out how to do this using the expression builder. If anyone can help or show me another method to do this I’d be grateful. Thanks.

This discussion is locked

All Comments