W
wieczo.yo
Hello,
I have to maintain a database which stores the working times of the
employees of a small company. We are using an old application(I have to
rewrite it later) which stores the labour times of an employee in a
local database and then the times are transmitted to the database of
our boss which contains the times of all employees. When a fellow
employee has sent her data for a month(e.g march 2006), it is stored in
her local DB that the times are booked. When she deletes the local DB
and then writes the data of the same month(here march 2006), she can
book the data again(that is just a small glitch in the old
application). So the employee transmits the data and I have at least
two same entries.
Now I want to find all multiple entries in the Timeentries table. It
has the attributes: ID, PersonalNumber, Description, BeginTime and
EndTime. PersonalNumber is the id of the employee, Description has the
description of the things done between the DateTime-attributes
BeginTime and EndTime.
I have written a rather complicated VBA sub to find the multiple
entries, but I wonder if there is a way to do it without programming.
Thomas Wieczorek
I have to maintain a database which stores the working times of the
employees of a small company. We are using an old application(I have to
rewrite it later) which stores the labour times of an employee in a
local database and then the times are transmitted to the database of
our boss which contains the times of all employees. When a fellow
employee has sent her data for a month(e.g march 2006), it is stored in
her local DB that the times are booked. When she deletes the local DB
and then writes the data of the same month(here march 2006), she can
book the data again(that is just a small glitch in the old
application). So the employee transmits the data and I have at least
two same entries.
Now I want to find all multiple entries in the Timeentries table. It
has the attributes: ID, PersonalNumber, Description, BeginTime and
EndTime. PersonalNumber is the id of the employee, Description has the
description of the things done between the DateTime-attributes
BeginTime and EndTime.
I have written a rather complicated VBA sub to find the multiple
entries, but I wonder if there is a way to do it without programming.
Thomas Wieczorek