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

Lookup table question

P: n/a
JK
I have two linked tables. One with several million records that include
"price paid". The second with price increments like "Between 1 and
100,000" and "Between 100001 and 200000" etc. Is there some way to link
them so that I can sum and count by increment?

Kinda like Excel's vlookup function with a "false" at the end so it
looks up the next value?

Feb 18 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"JK" <jk*******@yahoo.com> wrote in
news:11**********************@g47g2000cwa.googlegr oups.com:
I have two linked tables. One with several million records
that include "price paid". The second with price increments
like "Between 1 and 100,000" and "Between 100001 and 200000"
etc. Is there some way to link them so that I can sum and
count by increment?

Kinda like Excel's vlookup function with a "false" at the end
so it looks up the next value?

If your lookup table contains a column for the low value and a
separate column for the high value, put the two tables into the
query grid, don't link them, and just use criteria to select
the right value.

Example 1) lookup.lowval <= maintable.pricepaid, and
lookup.highval >= maintable.pricepaid
Example2 maintable.pricepaid Between lookup.lowval and
lookup.highval


--
Bob Quintal

PA is y I've altered my email address.
Feb 18 '06 #2

P: n/a
JK
Bob

Thanks so much!

John

Feb 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.