MS Access Str() Function

Return a number as a string:

SELECT Str(42) AS ConvertToString;

Definition and Usage

The Str() function returns a number as a string.

Str( number)

Parameter	Description
number	Required. The number to convert to a string

Works in:	From Access 2000