I want to be able to use DLookup in a query, extracting a value from a
Table to form a new field in the query.
For interest, I have a record of Beetle sightings and record a unique
number (J) for each species. I have a table that defines Beetle
families as those that belong to the set J(lowest) and J(highest).
eg the Family A consists of all beetles with numbers between 5 and
1500.
I want to show a report of selected beetles, presented by named
families, without needing to add the family to every record.
Can anyone advise?
Thanks,
Brian