G
Greg Jesky
I may be asking more than access can deliver.
I have 2 tables:
In the first table I have a mobile telephone number with the average number
of minutes used the previous three months together with additional fields
In the second table I have a record for each several different rate plans
provided by wireless providers(Cingular,Verizon T-Mobile,etc)
I would like to pull each record from the first table and select in the
second table the record with cell plan minutes greater than the minutes used
in the first table.
For example
Table 1
Unit # Average Min Used Service Provider
770 333 3333 637 Cingular
Table 2
Cell Plan Minutes included in Plan Service Provider
001 400 Cingular
002 600 Cingular
003 800 Cingular
I would like to select from table 2 the record for cell plan 003 with 800
minutes because 637 is greater than 600 but less than 800. Can this be done
with my access 2000 and how would you do it?
Thank You,
Greg
I have 2 tables:
In the first table I have a mobile telephone number with the average number
of minutes used the previous three months together with additional fields
In the second table I have a record for each several different rate plans
provided by wireless providers(Cingular,Verizon T-Mobile,etc)
I would like to pull each record from the first table and select in the
second table the record with cell plan minutes greater than the minutes used
in the first table.
For example
Table 1
Unit # Average Min Used Service Provider
770 333 3333 637 Cingular
Table 2
Cell Plan Minutes included in Plan Service Provider
001 400 Cingular
002 600 Cingular
003 800 Cingular
I would like to select from table 2 the record for cell plan 003 with 800
minutes because 637 is greater than 600 but less than 800. Can this be done
with my access 2000 and how would you do it?
Thank You,
Greg