>We have all been there! :-)
>
>The easiest change you can do, but maybe not the fastest solution, will be to work directly with the table. Change the recordsources and controlsources to the table, and it's fields, and add simply add

SET FILTER TO NOT MONTH.COMPLETED IN MONTH

>
>>Thanks I'm going down that path now.

Hi Tore,

Better to start from the right approach at the beginning than re-design later. I would advise not even look into this solution and take local view route for now. It's quite simple and would be easier to adjust later if changing back-end.