Access database query

[Guest]

My Access database has now gone over 1,000 items. Each item has an automatic
ID numbering. But after it got to 999, every item now just says "+03". How
do I get it to continue numbering from 1,000?

 

[Jeff Boyce]

Leknut

Your description sounds like you are working directly in your tables. You
will find that Access tables work well to store data, but Access forms work
MUCH better to display/enter/edit data.

"+03" is shorthand for scientific notation -- if you widen the field/column
on the screen, you should see the entire number. Again, though, use forms,
not tables, to display the number.

 

[Joseph Meehan]

Leknut

Your description sounds like you are working directly in your tables.
You will find that Access tables work well to store data, but Access
forms work MUCH better to display/enter/edit data.

"+03" is shorthand for scientific notation -- if you widen the
field/column on the screen, you should see the entire number. Again,
though, use forms, not tables, to display the number.

In addition to forms, you can also use a query.

 

[Guest]

Thank you very much for your helpful reply. Such a simple thing and yet
causing me much vexation. I am most grateful

"