Reply to thread

Message: [QUOTE="Paul Dennis, post: 1610581"] Yep know about data normalization, however I need it because I need this in another query were I need to link 2 tables via the Year. Since the [Meeting Number] has the Year in it I have the data but you can only link one field to another you can't link a partial field. I have already created the field and run an update query for the existing data, but I wanted a clean way of updating the field just when a new record was created and not to have to run a query every time. I don't mind putting it on the form if I have to, I would just change the font so it can't be seen, however don't want to use an event, can I use the Row Source to say =Left([Meeting Number],4)? [/QUOTE]