Hi 
I am trying to set up a query. i have to work out the cost of a phone call with the use of three fields--
i have: lenght of call, country call code-e.g england is +44(these are fields in my query) and then the cost per minute values for each country call code(but these are in a table)
e.g.Country Code Region Cost per minute
+1 United States, Canada, Caribbean £0.20
+20 Egypt £0.30
+212 Morocco £0.30
How would i set up a query to solve this problem?#Can someone please help me???
I am trying to set up a query. i have to work out the cost of a phone call with the use of three fields--
i have: lenght of call, country call code-e.g england is +44(these are fields in my query) and then the cost per minute values for each country call code(but these are in a table)
e.g.Country Code Region Cost per minute
+1 United States, Canada, Caribbean £0.20
+20 Egypt £0.30
+212 Morocco £0.30
How would i set up a query to solve this problem?#Can someone please help me???
