Making access to identify and use data to insert into a field.

[Geni]

Im very bad at access as I am doing it for my chool project. And im stuck as i dont know in which way to achieve the following result.
I have created a form I use it for registration of people for my database project, I have field where user enters the date of birth and the next field therefore using formula generates the age of the person, I would like the next field to identify the age group of the person based on their age, I have three groups Adult, Junior and Senior. For example person aged 20 will go to Adult group, but how to make acess to work it out.
Thank You.

 

[jzwp22]

Welcome to the forum!

As this is a school project, I will just give you some hints. Create a table that has a field to hold the age group name (junior, senior, etc.). Now since each age group has 2 ages associated with it (and upper age value and a lower age value), that describes a one-to-many relationship which requires a separate but related table. Now some people may say that creating the second table takes normalization rules too far and that the upper and lower ages for each range should be captured in two fields in the first table. Now depending on your school assignment, you will have to determine the best way to handle it. If you use the two table approach described above, you will need a query to bring the upper and lower age limits together.

Once you have the table or tables set up, you will want to read up on the DLookup() function.