How do I setup this MS Access Forumla

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