stephaniem
Registered User.
- Local time
- Today, 00:26
- Joined
- Dec 26, 2012
- Messages
- 12
Create a count of records that were "open" during a given time period in the past
I posted this in the "queries" forum, but I'm thinking it's going to need some code work and you guys are the best:
Here's the setup:
This is a DB of product development records. The date the project is first entered is stored, as well as every date that an update is made. There is an open/closed flag on each record as well.
I need to create a trend chart that will show how many development projects were "open" during given months.
There is not guaranteed to be an update every month, but the project would still be open.
I'm thinking I need an input where the user can select a date range, and for each month within that date range, see if the month is between the first entered and last update of each project; or, if the project is open then if it is between first entered and current date. That record would then add to the count for that month.
Any ideas?
Appreciate your help. I really can't post a db on here, just because of the sensitive nature of the material. I'm pretty comfortable with vba, but can't figure out the best approach.
I posted this in the "queries" forum, but I'm thinking it's going to need some code work and you guys are the best:
Here's the setup:
This is a DB of product development records. The date the project is first entered is stored, as well as every date that an update is made. There is an open/closed flag on each record as well.
I need to create a trend chart that will show how many development projects were "open" during given months.
There is not guaranteed to be an update every month, but the project would still be open.
I'm thinking I need an input where the user can select a date range, and for each month within that date range, see if the month is between the first entered and last update of each project; or, if the project is open then if it is between first entered and current date. That record would then add to the count for that month.
Any ideas?
Appreciate your help. I really can't post a db on here, just because of the sensitive nature of the material. I'm pretty comfortable with vba, but can't figure out the best approach.