Setting a new value

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
 
L

Les

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