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.