Recent content by streetfox

Thank you very much. I will try this out as it seems to be much more sophisticated than my current solution. Please see below if you're interested. I leave it to the User of the Form which Periods she wants to compare. You are correct that an entry can be in different periods and this...

I have now searched quite a lot but maybe it's my english or can you point me to the correct post? I have one table with ID and Date 001, 31.12.2011 002, 31.12.2011 002, 1.1.2012 003, 1.1.2012 Now I would like to run an union query based on a form [Old Date], [New Date] which returns a table...