I'm new to Acces, dont know Union query.
I dont know how to put simple example. I've attached my current database.
Please, refer for tables "CELL_CS_KPI" and "CELL_PS_KPI" - as for input tables (importing through VBA).
Next I fill start and end dates, after I calculate KPI's by hour/day or...
Dears, please, help to solve following problem:
In Access I have a table with some data like
DateTime__________| a | b | c | d | e |
10.03.2016 01:00:00 | 1 | 0 | 4 | 3 | 7 |
...
etc.
I need to get following results:
1. total result for dates 01.03.2016 till 10.03.2016 - Expr1...