Forcing the field type
Is it possible to force the field type in the table resulting from a query?
Reason: Access2000 keeps giving me tables with field type = Binary!...according to MicroSoft this field type does not exist!!
These binary fields appear to be generated when the resulting data is 'mixed' eg.
"Q3 space 2000/2001". Also, If you then compact without removing the binary fields, it is well nigh impossible to re-open the database. Anyone else notice this? .. It doesn't seem to happen with Access97 How about Access2002?
Together we'll get there ....?....wherever there is