JeepsR4Mud
Registered User.
- Local time
- Today, 12:31
- Joined
- Sep 23, 2002
- Messages
- 70
I have a table called staff injuries. It has a check box field to not an outside referral to a hospital, etc. It is called OUTREF
Because I am interested in things like average number of accidents/week, etc. I also have a check box field called NONE. That way, the correct number of weeks are used in the average, because a record is created.
However, I think I need to create a "dummy" field for the OUTREF. When I use the report wizard to generate the SUM, AVG, MIN, and MAX, it always lists 1 as the MAX, which is the maximum number in one record. What I need is the MAX number in one week. I can sum the Yes/No in the report, but I can't use the AVG function with that calculated field.
So, it occurred to me that if I create a second field (which won't be displayed on my data entry form) where the values are generated from the OUTREF field. Something like if OUTREF is checked, the value in this field would equal 1, otherwise it is 0. I could then calculate my averages from this field.
Does that make sense?
I think I want to to this in a query.
Other suggestions welcome.
Thanks.
Gayle Ann
Because I am interested in things like average number of accidents/week, etc. I also have a check box field called NONE. That way, the correct number of weeks are used in the average, because a record is created.
However, I think I need to create a "dummy" field for the OUTREF. When I use the report wizard to generate the SUM, AVG, MIN, and MAX, it always lists 1 as the MAX, which is the maximum number in one record. What I need is the MAX number in one week. I can sum the Yes/No in the report, but I can't use the AVG function with that calculated field.
So, it occurred to me that if I create a second field (which won't be displayed on my data entry form) where the values are generated from the OUTREF field. Something like if OUTREF is checked, the value in this field would equal 1, otherwise it is 0. I could then calculate my averages from this field.
Does that make sense?
I think I want to to this in a query.
Other suggestions welcome.
Thanks.
Gayle Ann
