Dlookup Between two values in a table

[primagic]

I have a field on a form - Age.

In a table I have a list of Age ranges.

MinAge MaxAge AgeRange
10 20 10-20
21 30 21-30


What I am trying to do is whatever number is in the Age field, lookup the table and pull through the correct AgeRange depending on which numbers the age is between according to the min and max.

Any ideas

Regards
Andrew

 

[PHV]

=DLookUp("AgeRange","yourTble","" & [Age} & " Between MinAge And MaxAge")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[primagic]

Getting #Error

i now have in my source for the field:

=DLookUp("AgeRange","tblAgeRanges","" & [Age] & " Between MinAge And MaxAge")

Would it matter if MinAge & MaxAge were number datatypes?

 

[primagic]

Working. thanks for your help

 

[PHV]

What is the ControlSource of the Age control ?