Lee Case(month(Somedate) > 6; year(somedate)) + 1; year(get(somedate))) should give you a fiscal year. Sort by that. Stephen ---------- "We were promised a society of philosophers. But the Blogosphere is looking more and more like a nation of ankle-biters." --- Steven Levy On Mar 23, 2011, at 5:50 PM, Lee wrote: > I did something very similar in version 5 over 10 years ago but I'm sure the advancement of filemaker in that time would have a more efficient way of doing it now. > > On 24/03/11 10:49 AM, Lee wrote: >> Hi, >> Its actually a little more complicated than that. >> The 'years' are the financial years starting July to June each year. so the running totals would be for each financial period. >> >> Lee >> >> On 24/03/11 10:39 AM, Lee wrote: >>> Hi, >>> Thank you to Corn and Stephen for the answer to my last query on layout changes in 11. >>> >>> I have a list of amounts ($) that have been entered during each year. I'd like to have a total (running) of each year's amounts. >>> I have a separate field that identifies each year but how would I create an onscreen running total for each year. >>> >>> Lee >> > > --