Adding Data into Table

  • Thread starter Thread starter Abedin
  • Start date Start date
A

Abedin

Hi all,

I have tables of calling rates. I have 5 tables as follows:

_tblAccount - It's an account type such as pre paid or post paid
_tblEmployees
_tblProvider - list of all the providers. I have 7 so far.
_tblProviderRates - I have different rates from 7 different providers.
_tblReport - This is a detail table. I am importing EmployeeID,
ProviderID, ReportDate, CountryCode, and CallingSec in this table.

I want to include rates in this detail table from tblProviderRates.

For example, I have customers who have used 3 different providers with
3 different rates. I want to show them in my tblReport table.

Now, they supposed to match with calling codes as for example again;
provider A rates for CountryCode 1 is 0.009 and provider B rates for
CountryCode 1 is 0.010. I want to see these rates in my tblReport.
Once I have this I can do some artihmetic.

Thanks.
 
You can use VLOOKUP for this. If your tblProviderRates covers all 7
providers next to each other, then you can convert the Provider into a
number (1 to 7) which can then be used to determine which column from
the composite rates table is used.

Hope this helps.

Pete
 
Back
Top