Em Andamento

Need Query and Report

This query evalutes time. Please be careful in your query to note that 1400 - 1330 is not 70, the answer is 30 minutes or .5 hours.

The query will evaluate travel time and return a true or false based on three arguments.

All of the fields listed below can be found in the 2 tables of the attached database

**Variables.**

Maximum Trip Time = T1

T1 = LoadTime + UnloadTime + (TravelTime * OnBoardFactor)

Maximum Expected Time = T2

T2 =

If [continuation of call] is false then

EalryTolerance + T1

Else

LateTolerance + T1

End if

If [continuation of call] is false then

Client Return Time = CR = DoTime ??" AppointmentTime

else

Client Appointment Time = CA = Appoinment Time ??" PuTime

End if

MJTime = DoTime ??" PuTime

Arguments

If MJTime > T1 then True, False

If CA > T1 then True, False

If CR > T2 then True, False

The query should bring back the records where the result is True.

A report should be generated showing the records that are true and the result.

Ticket Client AppointmentTime PuTime DoTime True Value > Value

12231 Jones 15:00 1300 1430 CA 120Minutes > 110 Minutes

You will notice that client name is not part of the Transport table. This is because of client confidentiality. Please include Client in the report.

The query will need a form to enter a date or date range to run against.

The query form will allow the user select one two or all three arguments.

Please add the query, form and report to the attached database.

## Deliverables

1) the attached database with the form, query and report in proper working condition

2) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

MS Access2000, windowsxp and windows2k

Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: travel and transport, range query, range maximum query, trip report, travel report, query table, engineering work report, work based report, report table, ticket add fields, value engineering, query query, report client, ticket fields, php appointment database, site query form, return query database php, report add php, end user report, php appointment time, transport site, need 110, transport ticket, php report table, continuation php

Acerca do Empregador:
( 14 comentários ) United States

ID do Projeto: #3027346

Premiar a:

ekam

See private message.

$42.5 USD em 4 dias
(111 Avaliações)
5.7

13 freelancers are bidding on average $33 for this job

justserg

See private message.

$11.9 USD in 4 dias
(143 Comentários)
6.8
TakeRealUK

See private message.

$34 USD in 4 dias
(552 Comentários)
6.7
amiratavw

See private message.

$42.5 USD in 4 dias
(144 Comentários)
6.1
techzonevw

See private message.

$42.5 USD in 4 dias
(156 Comentários)
5.8
saadrahmanvw

See private message.

$34 USD in 4 dias
(23 Comentários)
4.4
stolevw

See private message.

$12.75 USD in 4 dias
(28 Comentários)
2.6
hazels

See private message.

$21.25 USD in 4 dias
(4 Comentários)
2.2
chrisxp

See private message.

$34 USD in 4 dias
(0 Comentários)
0.0
puvakil

See private message.

$34 USD in 4 dias
(0 Comentários)
0.0
savortechno

See private message.

$38.25 USD in 4 dias
(0 Comentários)
0.0
iterant

See private message.

$34 USD in 4 dias
(0 Comentários)
0.0
mattonbriggs

See private message.

$42.5 USD in 4 dias
(0 Comentários)
0.0
smartwesam

See private message.

$39.95 USD in 4 dias
(0 Comentários)
0.0