![]() ![]() for one set of criteria this code works just fine but for others it keeps giving me runtime error '3354'. WHERE ReadTime = (SELECT TOP 1 analyzedCopy.ReadTime FROM analyzedCopy WHERE analyzedCopy.readings_miu_id = A.readings_miu_id AND analyzedCopy.ReadDate = A.ReadDate ORDER BY analyzedCopy.readings_miu_id, analyzedCopy.ReadDate, analyzedCopy.ReadTime)Īnd before this i'm filling in the analyzedCopy table from other tables given certain criteria. im using this code: SELECT readings_miu_id, ReadDate, ReadTime, RSSI, Firmware, Active, OriginCol, ColID, Ownage, SiteID, PremID, prem_group1, prem_group2 I'm having a problem running an sql in ms-access.
0 Comments
Leave a Reply. |