hi, thnx in advance. I am building a db for a sports event. I have 2 tables. participants and agecalc. in agecalc I have fields age and age-group. if age is 3 yrs then age group is 3-4 yrs and so on. in the form created using "participants", there is a field calculating the age based on the date of birth.it displays the age in years. in the same form, I want to have a field which will automatically display the age group as well. I want the field to grab the final answer from the age calcuting field and refer to the "agecalc" table. then to display the appropriate age group. I tried this, but did not work. please help: =(SELECT [Age_group]![agecalc] FROM [agecalc] IIF([Age]![agecalc] = [Age] ,0)) thankyou

Try this =DLookup("Age_Group","ageclac","age = " & [Age])

hi thnx, I tried but it did not work. :o(

The Dlookup command will definitely work for you. Review the Access help on that command. Where on the form are you putting that command?

Try this: =DLookUp("[Age_group]","agecalc","[age] = [age1]") I am not sure what the name of your text box on your form is for the age but put that name in place of age1.

it worked. thnx heaps.

Glad you got it working