MS Access Asc() Function

Posted by

MS Access

Asc()

Function

Example

Return the ASCII value of the first character in “CustomerName”:

SELECT Asc(CustomerName) AS NumCodeOfFirstChar
FROM Customers;


Definition and Usage

The Asc() function returns the ASCII value for the specific character.

Syntax

Asc(

character

)

Parameter Values

Parameter Description

character
Required. The character to return the ASCII value for. If more than one
character is entered, it will only return the value for the first character

Technical Details

Works in: From Access 2000