WHERE [Date entered] Between #1/1/2016# AND #31/12/2018#
I take an extract (wait come back) and it's not always on a fixed day.
What it should have in it is all data from 2016 - end of the last month.
So in feb it should look at Jan. March should look at feb.
I have this
Access SQL
I take an extract (wait come back) and it's not always on a fixed day.
What it should have in it is all data from 2016 - end of the last month.
So in feb it should look at Jan. March should look at feb.
In Excel I'd use something like
to get the end of the previous month.