Some question on access database

[Lynn Trapp]

Where can I find some help about access database.

Need good help file, please (*.chm, or pdf are fine).

Check out Jeff Conrad's Big List (link in my signature) for the best list of
help on Access anywhere.

How can I convert from integer to character ?
How can I convert from date to string ?
CStr([YourField])

How can I put leading spaces on a string ?

" " & [YourField]


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[John M]

Hello,
Where can I find some help about access database.
Need good help file, please (*.chm, or pdf are fine).

Some questions :
How can I convert from integer to character ?
How can I convert from date to string ?
How can I put leading spaces on a string ?

etc...

Thanks

 

[Lynn Trapp]

You can set the format of your field to "0000000"

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

Hello,
Cannot find any help. need a link, please.
Leading zeros or spaces : ( I mean if there is '123' string and I want
complete it to 7 characters, then it is : '0000123')
Need sample, code please.

Thanks

Where can I find some help about access database.
Need good help file, please (*.chm, or pdf are fine).

Check out Jeff Conrad's Big List (link in my signature) for the best list
of help on Access anywhere.

How can I convert from integer to character ?
How can I convert from date to string ?
CStr([YourField])

How can I put leading spaces on a string ?

" " & [YourField]


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[John M]

Hello,
Cannot find any help. need a link, please.
Leading zeros or spaces : ( I mean if there is '123' string and I want
complete it to 7 characters, then it is : '0000123')
Need sample, code please.

Thanks

Where can I find some help about access database.
Need good help file, please (*.chm, or pdf are fine).

Check out Jeff Conrad's Big List (link in my signature) for the best list
of help on Access anywhere.

How can I convert from integer to character ?
How can I convert from date to string ?
CStr([YourField])

How can I put leading spaces on a string ?

" " & [YourField]


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html