Access database design + special query

Completado Publicado Sep 2, 2010 Pagado a la entrega
Completado Pagado a la entrega

I run a VOIP long distance phone company. I have raw data for different costs to dial destinations from multiple different providers. I can put all the data in a single table and need a query that will select the best rate for each destination along with all other important details (provider id, country name, etc, etc).

Here is the biggest dillema with the query. Some providers will give a single rate for an entire country. For example, provider 1 is $0.02 for UK (any dial prefix 44 will be $0.02). Other providers may give thousands of different rates for that same country. For example provider 2 will say: 442205 will be $0.01, 44242 will be $0.05 and 44 is $0.025 (When a single provider gives a rate for 44 and has a rate for 442205 as well, the 44 rate will ONLY be used if a longer prefix does not exist from the SAME provider). I need the query to determine the cheapest price for each prefix. In the above examples, we would keep 442205 prefix (in the query result) as it is cheaper ($0.01) than the general 44 ($0.02) from provider 1. However 44242 would not be kept because provider 1 is $0.02 for every destination starting with 44.

I hope I was able to explain this job to the fullest. I am willing to provide additional examples and aid to anyone who feels they can do this.

It is good for this to be done is Microsoft Access so I can easily import updated rates when I get them and also will be able to export the query results in CSV so I can import them to my billing software.

Procesamiento de datos Microsoft Access SQL

Nº del proyecto: #785325

Sobre el proyecto

43 propuestas Proyecto remoto Activo Sep 15, 2010

Adjudicado a:

vrushabh

please check pmb

$40 USD en 3 días
(1 comentario)
2.6

43 freelancers están ofertando un promedio de $117 por este trabajo

consus

Hello Sir Please check inbox for bid details Thanks

$100 USD en 2 días
(21 comentarios)
6.9
HussienSharaf

HI, I m the best SQL and MS Access expert. Plz send me the table and i ll do the query. Hussien Sharaf

$50 USD en 1 día
(43 comentarios)
6.8
MAnkita

Hello,Please refer your PMB. Thank you.

$250 USD en 5 días
(69 comentarios)
6.1
eperfections

Please see PMB

$125 USD en 3 días
(83 comentarios)
6.0
kulhanekd

I can do this.

$100 USD en 3 días
(36 comentarios)
5.9
mrbrave

Ready to start now...

$100 USD en 5 días
(45 comentarios)
5.1
Wonderer

Hi I can do that Thanks Al

$150 USD en 5 días
(39 comentarios)
5.0
sikandermandal

Please See PMB

$250 USD en 1 día
(11 comentarios)
4.9
fedalal2

Hi, I have more 10 years in MS Access and SQL Server and realy guru in this. I can help you with this query. Please send me example of your database. Alex

$50 USD en 1 día
(18 comentarios)
4.8
shmai

have a glance at Pm. regards,

$450 USD en 10 días
(19 comentarios)
4.9
KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

$75 USD en 3 días
(30 comentarios)
4.6
frehmanpk

Respected Sir, Please see PM for details. Kindest regards.

$150 USD en 0 días
(15 comentarios)
4.5
florinserban

Hi. Please check PM for details. Thanks!

$80 USD en 0 días
(14 comentarios)
4.3
tfcarlos

i can do it. I am expert Microsoft Certified Professional an bachelor in computer science. see PMB pls

$250 USD en 3 días
(1 comentario)
4.0
DISoln

Hi, I am an SQL expert, I assure quality on-time delivery. DI Solution

$75 USD en 1 día
(7 comentarios)
3.9
mango953

Hi. I work with File Maker Pro which is more powerful and easier to work with than Access, nevertheless I can design a file in FMP that will send the info to Access for you to import. If you want a sample of it, let me Más

$200 USD en 15 días
(3 comentarios)
3.5
RedhopIT

Ready to Start,Check Pm Please.

$30 USD en 2 días
(3 comentarios)
3.5
lupus78

MS Access pro here to help you.

$120 USD en 3 días
(1 comentario)
2.4
counterpuncher

For your consideration...

$75 USD en 3 días
(3 comentarios)
1.6
proitagent

Hi there, I am a database professional with 12 + years experience in application development, database design and implementation and am very keen to deliver you the application within 3 days. My favorite datbase en Más

$110 USD en 3 días
(1 comentario)
1.7