Make Table Query

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a maketable query that requires a date from the
user and enters it into a field for each entry. So far so
good, but it stores the date in the new table as a
binary. How can I get it to store as a date? I tried
formatting in the query design to no avail.

I use this date to compare to other dates in later queries
and I get a type mismatch error which is why I thought it
was best to get the first maketabel field as a date.

Thanks!
 
Try forcing the date to a datetype by wrapping it in a CDate conversion.

CDate([Input the Start Date])
 
You sir are a genius! Thanks!

Mike

-----Original Message-----
Try forcing the date to a datetype by wrapping it in a CDate conversion.

CDate([Input the Start Date])
I have a maketable query that requires a date from the
user and enters it into a field for each entry. So far so
good, but it stores the date in the new table as a
binary. How can I get it to store as a date? I tried
formatting in the query design to no avail.

I use this date to compare to other dates in later queries
and I get a type mismatch error which is why I thought it
was best to get the first maketabel field as a date.

Thanks!
Click to expand...
.
Click to expand...
 
Back
Top