Converting Date/Time to Date

J

Justin

need to know how to change a table that has Date and Time to just Date, when
i append to another table

for example, 8/30/2005 01:10:03am --> 8/30/2005
 
A

Allen Browne

See help on DateValue()

In the field row of your Append query, you will have something like this:
DateValue([MyDateField])
 
Top