Anonymous asked in Computers & InternetProgramming & Design · 7 years ago

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)

1 Answer

Still have questions? Get your answers by asking now.