Hi again, When I run the code you posted I get all ten rows that fulfill AnalysisQuarter = '2016Q4'. So no hidden spaces or other characters I beleive. Yes, that is another solution. As a mentioned I already have a walkaround. The problem with both your and mine workaround is that Access will treat it as a "new table" and possible grouping of tables within Access get lost, which is a bit annoying. As a I mentioned when I answered @RW9 two more rows become deleted when I run the code one more time. Strange... Regards, Gustav
... View more