scale

-- scale (chart time axis scale)
-- MS ACCESS JET
-- incr view: n (incremental number from 0 to 49)
SELECT incr.n,
       DateAdd('d',-n-1,DATE()) AS a,
       DateAdd('d',-n,DATE()) AS b
FROM incr;