CAST/CONVERT function in Access


There is no CAST/CONVERT function in Access. But you can find a few equivalents for the convertion functions.

For example:

Cint(x)–CONVERT(smallint,x)

Clng(x)–CONVERT(int,x)

 Cstr(x)–CONVERT(varchar,x)

Cdbl(x)–CONVERT(float,x)

You can find more VBA functions  from Office Help files (within Access) if you need other data type conversion.

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s