Is it possible to make a "virtual" datatype conversion of a field 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 query both tables, can we do that programmatically without changing the datatypes of the two fields?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access 2000 data type conversion.
- Thread starter borach
- Start date
Hi1
You can create query like it:
SELECT XUNT.TypeUnitNo, XUNT.TypeUnitVersNo, XUNT.QrgType, Str([TypeUnitNo]) AS StrTypeUnitNo FROM XUNT;
>>> XUNT.TypeUnitVersNo = Long Type field
then save this query (e.g. name it "MyQuery"), create new query with using needed table and query "MyQuery" :
SELECT KREG.RegionName FROM MyQuery INNER JOIN KREG ON MyQuery.StrTypeUnitNo = KREG.RegionName;
Aivars
You can create query like it:
SELECT XUNT.TypeUnitNo, XUNT.TypeUnitVersNo, XUNT.QrgType, Str([TypeUnitNo]) AS StrTypeUnitNo FROM XUNT;
>>> XUNT.TypeUnitVersNo = Long Type field
then save this query (e.g. name it "MyQuery"), create new query with using needed table and query "MyQuery" :
SELECT KREG.RegionName FROM MyQuery INNER JOIN KREG ON MyQuery.StrTypeUnitNo = KREG.RegionName;
Aivars
- Status
Similar threads
- Locked
- Question
- Locked
- Question