Kids are never the problem. They are born scientists. The problem is always the adults. They beat the curiosity out of kids. They outnumber kids. They vote. They wield resources. That's why my public focus is primarily adults.
Application# is the primary key field in tbl-Approvals. The PK is not connected in any relationship with another field. Data Type Number (Single, Fixed, Decimal Places 2, Required, Indexed (no duplicates)).
A new application # is assigned for each new product and is versioned with each change. Ie new item 11549.00, versioned as 11549.01, 11549.02, 11549.99. So the next entry is 11549.100???
Issue: how do I convert the field and data from 2 to 3 decimals places with the new 0 value placed after the decimal point and NOT on the end as Access currently does .. ie 11549.099 and not 11549.990.
I have been successful in using an update query to copy from Application# to a new filed Application#1 which was set as a text field. I then used Ctrl+H to replace . with .0 which has given me what I want (as text). But now cant convert back to a number with 3 decimal places.
Help required please.
Scott Axton
@Reply 3 years ago
First of all if your table is really named tbl-Approvals I would rename it getting rid of the "-".
Forms, fields, queries, variables should only contain letters and, occasionally, numbers. If you ever do any programming or even complex queries there is a good chance that you will run into errors. The - tells access subtraction ie tbl minus Approvals not what you intend.
The short answer is you will probably need some VBA and a second field for your version number. Then to bring in together via concatenation.
Lots of concepts here and I have no idea what your experience level is with Access.
Start out by checking out the Format function.
Watch the Sequential Numbers video. Especially the extended cut.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
