Sintaxis of CONVERT function in MS ACCESS

[Pjcol]

Hi

i need examples for the CONVERT function in MS ACCESS.

thanks

 

[Jerry Whittle]

There is no Replace function in Access. Are you talking about the StrConv
function or possibly the Replace Function? Either way press Ctrl + g to bring
up the VB window. Then go up to Help to bring up the Visual Basic Help.
Search for what you are looking for. Usually there are examples provided.

 

[John W. Vinson]

Hi

i need examples for the CONVERT function in MS ACCESS.

thanks

The CONVERT function is not supported in MS ACCESS.

What are you trying to accomplish? There are other functions which do the same
job as CONVERT in SQL.

John W. Vinson [MVP]

 

[Michel Walsh]

Conversions are much more automatic than with MS SQL Server, but if you need
to force a conversion, use Int( ), CDec(), ...





Hoping it may help,
Vanderghast, Access MVP