R
RCM
I have created a sub query to compare fields between records. The query
works fine, but the resulting Previous record field creates an unsupported
object which will not allow me to link the query with another query. The
following is the sub query:
PrevTimeOut: (Select Max(TIME_OUT01) from TOTime1 where TIME_OUT01 <
Turn1.[ORTIMEIN01] and ADMDT = Turn1.[ADMDT] and ORTIMEIN01 <=
Turn1.[ORTIMEIN01])
PrevTimeOUt is then subtracted from the current record ORTIMEIN01 to give me
elapsed time in a new field called TurnOverTime. I need the TurnOVerTime
field to link to the main query for output to several reports. The problem
is that the Query where this sub query is located becomes an unsupport
object. Any help will be greatly appreciated.
works fine, but the resulting Previous record field creates an unsupported
object which will not allow me to link the query with another query. The
following is the sub query:
PrevTimeOut: (Select Max(TIME_OUT01) from TOTime1 where TIME_OUT01 <
Turn1.[ORTIMEIN01] and ADMDT = Turn1.[ADMDT] and ORTIMEIN01 <=
Turn1.[ORTIMEIN01])
PrevTimeOUt is then subtracted from the current record ORTIMEIN01 to give me
elapsed time in a new field called TurnOverTime. I need the TurnOVerTime
field to link to the main query for output to several reports. The problem
is that the Query where this sub query is located becomes an unsupport
object. Any help will be greatly appreciated.