lilpumpkin
New member
- Local time
- Today, 07:44
- Joined
- Nov 8, 2006
- Messages
- 3
Hi
I have a table with the following fields
Site ID
Location
Design Scheduled Date
Design Actual Date
Transmission Scheduled Date
Transmission Actual Date
Decommission Scheduled Date
Decommission Actual Date
I want to create a report that shows all activities where the scheduled date is within a Beginning Date and an End Date taken from a user inputted form, but excluding all records where that activity is already completed ie only show records Actual dates are null for that activity.
Is there a way I can create this report without having to go down the path of sub queries and sub reports. There are a lot more activities than the ones listed above and would prefer not to do that.
Thanks
Natalie
I have a table with the following fields
Site ID
Location
Design Scheduled Date
Design Actual Date
Transmission Scheduled Date
Transmission Actual Date
Decommission Scheduled Date
Decommission Actual Date
I want to create a report that shows all activities where the scheduled date is within a Beginning Date and an End Date taken from a user inputted form, but excluding all records where that activity is already completed ie only show records Actual dates are null for that activity.
Is there a way I can create this report without having to go down the path of sub queries and sub reports. There are a lot more activities than the ones listed above and would prefer not to do that.
Thanks
Natalie