Please can you help - I run a query each month to show our sales figures.
Is there a way I can automatically get the query to show data up to the end of the month before; either that or prompt for an 'end' date only.
I've tried 'dateserial' but not having any luck.