Re: get results for previous 3 months VAT reasons
I would use a form, and select the dates you want, so you can use
between format(datea,"long date") and format(dateb,"long date")
others will give a different suntax to "long date" - but you need a format in the UK.
secondly, I would use a function to read the date (as above) - if you use a form reference you will probably get a 3061 (I think) error.
Either that, or manually enter the dates you want in the query
but note that if you enter #01/04/2019# it might work as #Jan 4th 2019#. Just be prepared for that.
Gemma was my dog
if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.