[AccessD] Comparing date and time

I think that you can do this by doing a DateAdd() to the date field itself,
since without a time specified it will default to midnight. Therefore a
DateAdd() using the number of minutes indicated by the time ought to produce
a genuine datetime value.

Arthur

On 11/23/07, David Emerson <newsgrps at dalyn.co.nz> wrote:
>
> Thanks Andy,
>
> I have simplified the problem.  Ultimately I need to compare two sets
> of dates and times to get all records that fall between one date and
> time, and a second date and time.
>
> I could use your suggestion and do similar comparisons with the end
> date and time as well.  I would be interested though in finding out
> how to create a full date/time from two separate fields.
>
> David
>