Recent content by Hejren

Hmmm - now I have a new problem in relation to this: is it possible to just find these rows WITHOUT merging them? I have to find them and replace them with the data from the query described above, and this will probably be done by 1. Finding & merging data (solved) 2. Create tempTable and...

What I mean is, that the result of the query will still give me two rows, if there were originally three dates following each other with only a day between IndmDate and UdmDate. So if this is the original data: CprNr InstId IndmDate UdmDate 1234567 17 14-03-2009 31-10-2010 1234567 17...

Thanks a million times to both of you! This works perfectly - at least when there are only two rows, but now at least I know the way to go from here.

I am relatively new to MS Access (and totally fresh in this forum :)), and I have been asked to create the following query on a single table: First - my table's structure: ID - (PK) int CprNr - int InstId - int IndmDato - Date UdmDato - Date ... And here's the challenge: Find posts...