I know it's bad form to store a calculated field in a table but here's the situation. The calculated field is for lab sample numbering. Due to very small labels the number has to be kept as short as possible so I created a combined number using the year followed by four digits like so 13-0001. This works fine in the query but I also need to store this number to be used / joined to another table for the results of the tests performed on the lab sample. How can I store the sample number in the underlying table or is there a way to do this numbering right in the table? Thanks!