By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,269 Members | 1,506 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,269 IT Pros & Developers. It's quick & easy.

Referring to tables in a query

P: n/a
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

Sep 17 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sep 17, 1:45 am, mana...@sportsvl.com wrote:
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
You could probably use nested iif statements in your SQL string to
create a calculated field, but you can't sort or group by calculated
fields. You might be able to turn it into an Insert Into statement to
populate a properly structured temporary table which could then in
turn be used for the report.

Sep 17 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.