find duplicates in time and date records II

[lateacher]

I am still in trouble!

1) I would like to know how to create this multikey field.

2)What kind of field is (date, time, number

[LiveOak]

The short answers are:

1) Using a script or calculation

2) The multi-key is a text field

3) 0830 to 2030 by 15 minutes gives 48 intervals

4) You will just relate the multikey to the multikey in the same file to check for overlap.

The exact script or calculation will probably take about an hour to work out for the script and longer for the calculation, kind of beyond the scope of this form. You might want to hire some help with this as it is definitely an advanced problem. The basics of the script are to take the start time and build a multikey entry, increment by 15 minutes, compare to the end time, if you aren't there yet, loop and build another entry until the interval is covered. I think this can also be done as a calculations (I don't know exactly how, but probably the mother of all case statements.) I'll ask Ocean West, he just got through doing one of these, but probably used a script.

-bd

(P.S. When you post a follow-up question, PLEASE make it part of the same thread, it's it much easier that trying to track multiple threads. Remember, the moderators and administrations answer more that just your questions!)

[lateacher]

Thank you again for your cooperation!

If you have another solution, I will be grateful.

Silvia

[ August 07, 2001: Message edited by: lateacher ]

[LiveOak]

We've done about 3 of these and this seems to be the best approach. If you are looking for something simpler, I'm afraid it just isn't a simple problem.

-bd