Lookup table question

[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?

[Bob Quintal]

"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.

[JK]

Bob

Thanks so much!

John