阅读背景:

MS ACCESS中的子查询:每个日期每个“人”只选择一条记录

来源:互联网 

I am using a table called analyzed in Microsoft Access. It has many fields but the three ones being used for filtering in this case are analyzed.readings_miu_id, analyzed.ReadDate, analyzed.ReadTime. I need to pull the records from the "analyzed" table where readings_miu_id are grouped together then sorted by ReadDate but showing only the last entry for said date which could be the highest valued time in ReadTime. I've created a query:I am using a table called analyzed in Microsoft




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: