Format Date in Make Table Query

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

I want to add a "NextReviewDate" field in a new table
using the Make Table query. I am able to do this by
inserting a [NextReviewDate: ""] into my query. However,
I also need the new field to have a Date datatype.

How do I include the date format in my Make Table query?
 
Access will automatic try to determine the data type. If
you start a new table in datasheet view and type in a
date, Access will change the datatyep to Date. If you
used "NextReviewDate: now()" it will create a date field
type.
 
Back
Top