SQL Type conversion in MSAccess 2002

W

whocares

I am running the following Query from ASP 3.0 via ADO

SELECT Report.RecordID, Report.ReportNumber, Incident.IncidentDate,
Incident.ShipName, report.RegionID
FROM Report, Incident, [translation]
WHERE Report.RecordID=Incident.RecordID AND
report.regionID = translation.Label;


The problem I have is that

"report.regionID is an LONG INT"

and

"translation.Label is a TEXT"


Of cource some type of conversion is required but I don't know the SQL
syntax.

Help!
 
Top