Dear June7, bob fitz
Thank you for replies, however.
I am lossed with & "/1/" & statement, Could you please explain.
P.S. I know about sub-queries, and about reserved words, this was just an example of my problem.
Hello,
I have a problem with summing data based on criteria: I want the average of last available 3 figures in Data column (excluding Null) for certain UserID.
TableID UserID Year Month Data
1 1 2016 Nov 100
2 1 2016 Dec
3 1 2017 Jan...