Help with query that matches dates

[Dave]

I have 2 tables that I want to query. Both have dates that I want to join.

The problem is one table has just a date and the second table has date and
time. As a result there is no match.

Is there a function that strips the time or will convert the field to just a
date?

Both tables are using these fields as a date.

Thanks

 

[madhouse]

In VBA or Macro or Field property try:
Format(me.date,"Short Date")

Madhouse

 

[John Vinson]

Is there a function that strips the time or will convert the field to just a
date?

Yep: DateValue([datetimefield]).

John W. Vinson[MVP]

 

[Dave]

Thanks I got it to work using this!

Is there a function that strips the time or will convert the field to just
a
date?

Yep: DateValue([datetimefield]).

John W. Vinson[MVP]