Auto update upon insert
Posted on 2002-06-19
Is it possible to have access auto update field values based on what the user has already input. For example, if there are three fields: A, B, C -> user is asked to input A and B, and have access then automatically update the value for C as the concatination of the string A+B. Is there anyway to run an auto query as the values are inputted. This of course works in excel, but does it in access?
On an unrelated note, is there a way to use the date field for only month and year or would that have to be text.