Setting a new value

  • Thread starter Thread starter Calvin Shane
  • Start date Start date
C

Calvin Shane

If I want to set a field called DateClosed into two
values, both of whom will be used in a later calculation,
do I set the new value as:

DateClosed2: DateClosed (in my query), or
DateClosed: DateClosed2

I will use both separately in a calculation:

MTTR: Datediff:([DateCreated],[DateClosed2])/60 AS MTTR
"x.xx" where x is hours, and xx is
hundredth hours

MTBF: Datediff:([DateClosed],[DateCreated])/60 AS MTBF
in same format as above

Any thoughts?

CALVIN
 
Hi,
I'm not sure why you need 2 fields. You can use the
same field in both calculations.
 
Back
Top