"JK" <jk*******@yaho o.com> wrote in
news:11******** **************@ g47g2000cwa.goo glegroups.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.price paid, and
lookup.highval >= maintable.price paid
Example2 maintable.price paid Between lookup.lowval and
lookup.highval
--
Bob Quintal
PA is y I've altered my email address.