Please help! I am on v9. I have 2 date fields - date_reported and date_closed. I have to pull data from 6/1/04 to 6/30/04 but the data in both fields can and are different. Each time I try this, I only pull data from either date_reported, then date_closed only shows the closed of that group (I hope that makes sense). I need to have 2 seperate counts. Thanks for your help!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formula Question
- Thread starter sclark415
- Start date
Sorry if this is a double reply but when I replied the first time I received an error.
Have you tried using the "running total" function?
In there you should be able to set it up to count all records where date_closed is between 6/1 and 6/30
and then you can create a new running total to count all records where date_reported is between 6/1 and 6/30
I am using v10 so I am not sure if the screens have changed but on the running total screen you can set
1. The field to summarize (type of summary = count)
2. How to evaluate the count (on change of record, field, or group or by using a formula). My guess is that you would need to use a formula so you could "say" date_reported between 6/1 and 6/30 (using the real\correct syntax of course)
3. When to reset the counter. (never, change of field, change of group, or with a formula.)
I use this HECK out of this function. I have a report where I have to count records based on about 30 different scenarios (30 different totals) and this was the easiest way that I found.
Have you tried using the "running total" function?
In there you should be able to set it up to count all records where date_closed is between 6/1 and 6/30
and then you can create a new running total to count all records where date_reported is between 6/1 and 6/30
I am using v10 so I am not sure if the screens have changed but on the running total screen you can set
1. The field to summarize (type of summary = count)
2. How to evaluate the count (on change of record, field, or group or by using a formula). My guess is that you would need to use a formula so you could "say" date_reported between 6/1 and 6/30 (using the real\correct syntax of course)
3. When to reset the counter. (never, change of field, change of group, or with a formula.)
I use this HECK out of this function. I have a report where I have to count records based on about 30 different scenarios (30 different totals) and this was the easiest way that I found.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question