Data types & fields in Access 2000

Is it possible to make a “virtual” data type conversion in Access 2000? E.g. if a field is of the “long integer” data type and we want to relate it to a “text” (string) field in another table, in order to be able to join and query both tables, can we do that programmatically without changing the data types of the two related fields?