I need to constantly view data from the current date back to the previous 1st July. I know this could be done with a parameter in a query but I would prefer to set the query criteria and just click on the report.
That should allow you to see the data you want regardless of the date. Then when you go into next financial year just change the 1/7 date.
Hope this helps
