>
> Start_Month 12
> Start_Day 1
> Start_Year 2003
> Start_Time 8
>
> End_Month 12
> End_Day 15
> End_Year 2003
> End_Time 8
> I know I need to pull a query that brings back the records that
> would be overlapped. And if that recordset is empty, proceed with
> the insert. Otherwise, give the user a message that there is an
> overlap and take them back to the form.
>
> The problems are:
>
> 1) I can't figure out what should be in the WHERE clause.
Does your database support OVERLAPS?
> 2) Have I screwed myself by chopping up the dates?
Screwed is not a nice word, but you did make things difficult for
yourself.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
