Query or VBA?

[Gert]

I have a tabel with begin and end-dates (1 ID, begin and enddate per record)
and I want to check for gaps in those dates. Can I do this by means of a
query (and if so how?) or should I write a VBA program for this.

 

[Alex Dybenko]

Hi,
I would make in VBA - open recordset sorted by begin date, loop through it,
save record's begin and enddate and then compare with next record begin and
enddate

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com