求access数据的查询和插入语句

[mfhxy]

查询的表名realdata

Id DataTime FlowValue pHValue
1 2011/5/18 10:43:30 102.9 34.6
2 2011/5/18 10:45:00 102.9 34.6
3 2011/5/18 10:45:30 102.9 34.8
4 2011/5/18 10:46:00 102.9 34.6
5 2011/5/18 10:46:30 74.4 34.6
6 2011/5/18 10:47:00 74.4 34.6
7 2011/5/18 10:47:30 74.4 19.9

请各位大虾帮助下，将FlowValue字段时间为10:43:30至10:47:30的平均值，以及pHValue字段时间为10:46:00的数据插入至另外一张表HISdata。如何写SQL语句！

[打一壶酱油]

insert into HISdata select * from realdata where  XXXx

[中国风]

轉到Access版

[mfhxy]

[Quote=引用 1 楼 abcjun188 的回复:]
SQL code
insert into HISdata select * from realdata where XXXx
[/Quote]

平均值没有查询出来呀

[ACMAIN_CHM]

insert into HISdata (FlowValue,pHValue) select (select avg(FlowValue) from realdata where DataTime between #2011/5/18 10:43:30# and #2011/5/18 10:47:30# ),pHValue from realdata where DataTime = #2011/5/18 10:46:00#

[WWWWA]

insert into HISdata (FlowValue,pHValue)
select (select avg(FlowValue) from realdata where FORMAT(DataTime,'hh:mm:ss') between #10:43:30#
and #10:47:30# ),avg(pHValue) from realdata where FORMAT(DataTime,'hh:mm:ss') = #10:46:00#