To build a Access 2010 SQL Query for the table (tbPrices) below with the following requirements:
The query has to return the average of the last 4 Valid Dates (=1) starting with the previous date.
Today (01/11/2015) doesn't count.
There is no rule to define how many Non-Valid Dates we can have between Valid Dates.
The Query has to start searching ...
Skills: microsoft access administration, microsoft access programming