My query is connected to a source which is updated automaticlly every day. My problem is that I need the history data, too.
For example:
Data in source of 08/02/2016: a
Data in source of 09/02/2016: b
Now:
Data in query of 08/02/2016: a
Data in query of 09/02/2016: b
What I want:
Data in query of 08/02/2016: a
Data in query of 09/02/2016: a + b
How can I build a query which saves the history data?
I hope that anybody can help me.
Thank you for your help.
TSunami61
For example:
Data in source of 08/02/2016: a
Data in source of 09/02/2016: b
Now:
Data in query of 08/02/2016: a
Data in query of 09/02/2016: b
What I want:
Data in query of 08/02/2016: a
Data in query of 09/02/2016: a + b
How can I build a query which saves the history data?
I hope that anybody can help me.
Thank you for your help.
TSunami61