Access help, changing updates over a certain number?
I have this code for changing my birth date to soccer categories.
UPDATE T_Formulaire SET T_Formulaire.Niveau_Suggestion = "U" & Year(Date())-Year([T_Formulaire].[Date_de_Naissance]);
I want to make it so everything that gives over U17 (U18,U19,U20) writes senior.
I'm not pretty good with access and I would need a little bit of help with that!
[Date_de_Naissance]); (Missing part)
- Anonymous7 years agoFavorite Answer
Changing existing data by using an update quer :http://office.microsoft.com/en-gb/access-help/chan...