Hi all,
I’m building a report in access and I need some help on creating a formula. I’m counting how many open tasks our staff have in our database and I need counts for: Total, Due in next 7 days, due in 8-30 days, due in 31-60 days, and Over 60 days.
I have total, but I’m trying to write a formula that says: If the Target date is between today and today+7, then enter 1, else enter 0.
Is this the right way to do this?
Should I try something else?
And… what is the correct way to enter this formula?
*Access 2003
