I have two queries. on first, I have a values of fuel rate by second of many equipment. in second query, I have diferent ranges of time by equipment.
I want get sum of fuel rate between any range of time.
I merge variables Equipo1/Equipo2, and FECHA1/FECHA2. But I can´t compare date times, and calculate the sum. I tried with this formula but it don't works. appears message #INCOMPATIBLE:
sum fuel rate = sum ([fuel rate] where ( [tiempo]>[INICIO] and [tiempo]<[FIN])
please, could you help me?