跪求一条ACCESS统计查询语句

图片说明
需要用一条语句查询出StageA的最大值,最大值对应时间,最小值,最小值对应时间,FlowRate最大值,最大值对应时间,最小值,最小值对应时间
非常感谢!!!

select 'stageA',RecordId,DT,HighVolum,LowVolume,FaultCount,StageA,FlowRate from table_name where stageA=(select max(stageA) from table_name)
union
select 'FlowRate',RecordId,DT,HighVolum,LowVolume,FaultCount,StageA,FlowRate from table_name where FlowRate=(select max(FlowRate) from table_name)