Make Table Query Creates Binary Data Type

[Bill]

Hi,

I have a make table query in Access 2000 that has a "Date"
field that pulls data from a form. (Example: ([Forms]!
[Reports]![Date])

When the resulting table is created the date field has a
data type of "Binary" which causes issues with linking to
date fields in other tables.

Does anyone know why this happens and/or how to corrects
it?

Thanks

Bill

 

[Van T. Dinh]

Is the Control "Date" bound to a DateTime Field or is it simply an unbound
Control?

If it is an unbound Control, Access/Jet won't know what you/the user typed
in is DateTime as the data entry is simply a String of character.

If you use the normal DateTime format for your region in the data entry, you
may like to try:

CDate([Forms]![Reports]![Date])

rather than just [Forms]![Reports]![Date]

Alternatively, IIRC, you can simply set the format of the Control to one of
the DateTime format. Access seems to be able to pick up from the format
that you meant a DateTime value.

BTW, both "Reports" and "Date" are bad choices for names for user-defined
objects. "Reports" is an Access-defined Collection and "Date" is an inbuilt
VBA function.