Hi Folks
Im in the realms of calculated filelds within queries
Im now at a stage where I want another calucating field.
I log fauts/problems/issues to a simple database
This has a field called opendate
When the case is closed, which it updates a filed called closedate
The format is dd/mm/y hh:mm
I would like to perform something like the following
If closedate - opendate <24hrs then ouput a 1 in the field , if >24hrs then output a 2
Then I will do a dcount (very happy with dcount) on the vales 1 so I can get an idea of all calls closed in <24hrs and also if I dcount 2 I will see all calls that took over 24hrs too clear.
Once Ive done this , I can have varying fields with >24<48 >48<62 etc
Does that make sense ?
I have another date question.
I would like a another calculating field so that if the case was open and closed on the same day , i.e open at 15/8/2006 and was closed on 15/8/6 then I have a calculated field output a value of 5 or some other value ? (I will then docunt this as its for a report)
Im realy strugling here and would apreciate some pointers ?

Many thanks
Jimmy
Im in the realms of calculated filelds within queries

Im now at a stage where I want another calucating field.
I log fauts/problems/issues to a simple database
This has a field called opendate
When the case is closed, which it updates a filed called closedate
The format is dd/mm/y hh:mm
I would like to perform something like the following
If closedate - opendate <24hrs then ouput a 1 in the field , if >24hrs then output a 2
Then I will do a dcount (very happy with dcount) on the vales 1 so I can get an idea of all calls closed in <24hrs and also if I dcount 2 I will see all calls that took over 24hrs too clear.
Once Ive done this , I can have varying fields with >24<48 >48<62 etc
Does that make sense ?
I have another date question.
I would like a another calculating field so that if the case was open and closed on the same day , i.e open at 15/8/2006 and was closed on 15/8/6 then I have a calculated field output a value of 5 or some other value ? (I will then docunt this as its for a report)
Im realy strugling here and would apreciate some pointers ?


Many thanks
Jimmy