|
Home > Archive > MS Access database support > February 2006 > Lookup table question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Lookup table question
|
|
|
| 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 2006-02-18, 8:24 pm |
| "JK" <jkarevoll@yahoo.com> wrote in
news:1140290199.416659.226290@g47g2000cwa.googlegroups.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.
| |
|
|
|
|
|