autofill cells

[catphe10]

Hello All,

I am trying to create a database with access and was hoping to get a little help.

What i am trying to do is have multiple cells populate themselves.

so here is the situation.
In the first column i have a specific number, for example, 44005162020. (all items in the first column will have a number similar to this, all will have the same number of digits)
So in the 5 column i want it to auto populate with only the first digit from column 1. so it would be a 4
in column 6 i want to auto populate with the 2nd and 3rd digit. it would be a 40.
in 7th column would be 4th and 5th digit. it would be 05.
and so on.

Any help is greatly appreciated!

[orange]

Cells are specific to spreadsheet(Excel).

Excel allows users to crunch numbers,  maintain lists and share data.
 It also allows users to export and import  various types of data for manipulation and analysis.
 Access has more  functions, making it a more powerful and complex program.
 Users can  manage more data, and several users can work in an Access database  simultaneously.
 Access is ideal for managing business contacts, tracking  customer orders, organizing staff jobs,
 managing tasks and maintaining  product inventories.
From https://www.reference.com/technology/difference-between-access-excel-1c4db066f05c7675#

[pbaldy]

I would either store the separate components or the full number, not both. In any case, check out the Left(), Right() and Mid() functions.

[Micron]

You can do this in Access (like many things) but just because you can does not mean you should. Not only may this be an example of repeating stored data, if the full number should ever change, the parsed parts of your record are no longer accurate. Forms and queries, and code when necessary, are the preferred method of manipulating data presentation, so that the data does not change. However, if you must, then I'd create an update query and extract the values from the number using the Mid function. This calculation expression would go in the query design grid where you'd normally place the value you want the query to write to the table.
Here's a link on how to use the Mid function http://www.techonthenet.com/access/f...string/mid.php
If you don't know how to create an update query, there are lots of tutorials and information. Try searching on ms access calculated query field

Edit: decided to add the expressions for your case
Mid(44005162020,1,1)
returns 4
Mid(44005162020,2,2)
returns 40
Mid(44005162020,4,2)
returns 05