Making a 30 day Look Ahead Report

[mr_connell]

I have a Form that updates 4 tables. This form has a list of packages and each of the packages have several activities that the package has to complete and each of the activities has a Scheduled date, a Forecast date and an Actual date.
I would like to make two different reports:
1: if there is an activity for a package that is due in the next 30 days i need it to show up on the report. if there is no activity that is due in the next 30day for a package than i don't want it to show up on the report.

2: i would also like a report that shows what activities for each report have been completed in the last 30 days.

any help would be great thanks.

 

[MyBoo]

Create two queries and then base your reports off of them.

1. Create a query for where the criteria for Scheduled Date - Between Date() and Date() + 30

2. The other query would have the criteria for the Actual Date as - Between Date() and Date() - 30

Test these, then base your reports off of them.

 

[mr_connell]

Thank you...can you help with a new problem?

The advise you had for my last problem was great.
My new problem is. I have a Project table that has a relationship with a Package table. Each Project has several Packages and each Package has several Activities, and each Activity has a Scheduled Date, a Forecast date and a Actual date.
I want a query to show all Packages that have an activity that is more than 15 days later than the Scheduled date. I have racked my brain and can't figure it out. I'm sure it's something simple.

 

[giacomo]

have a look at the datediff function

hth,
Giacomo