Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft access training - numerica values

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - Numerica Values

microsoft access training - Numerica Values

ResolvedVersion Standard

Kathy has attended:
Access Introduction course

Numerica Values

Hi,

I have created a table in Access which has a column with a numeric value in it. I need to automatically insert zeros at the beginning of each number in the column. Can you let me know the best way to achieve this?

Thanks and regards.
Kathy

RE: Numerica Values

Hi Kathy, Thanks for the post, Re your problem: if in design view for the table, you type into the format line in the field properties for that field, the following; \0# you will find that a zero is automatically inserted before any number you type, (note you do not need to type the zero). hope that helps.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.