headbump
asked on
Overlapping Date/Time Entries in Microsoft Access Records
I have a huge table of progress notes that track who created the progress note, the date and time of the progress note and the client the progress note was written for. The problem is that some of the clients have overlapping progress notes for the same date and time, sometimes by the same staff person and sometimes by a different staff person. I need to be able to identify what progress notes have overlapping date and time entries for the same client. For instance, if a staff person create a note for Client A for 12/05/05 from 7 a.m. to 10 a.m. and then, for some reason, entered a second progress note for Client A for 12/05/05 from 9 a.m. to 11:00 a.m., I need to identify so it can be corrected. I've consolidated the records by Client, Staff Member and date and time. Now I need to contrast the records for each client and find the overlaps. Help!
George Lob
Why not just check if there is a note after the staff member enters the date, time, and client. Create a button that will activate the note area if there are no conflicting entries and if there are you could a) have the staff member enter different date and time or b) import the existing data and update the entry with the current info.
ASKER
Unfortunately its not my application. All I've inherited are the overlapping records and I need to find a way to weed through 400,000 plus records to find the overlaps.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.