Acc2002: Avg hrs of operation calculation

I'm trying to do something for the first time and falling flat on my face. I'd like to figure the average hours of operation per day for a business. Here's what I have: Private Sub Form_BeforeInsert(Cancel As Integer) Dim CurYr As Integer Const conLeapYrWks = [url removed, login to view] Const conLeapYrDays = 366 Const conWksYr = [url removed, login to view] Const conDaysYr = conLeapYrDays CurYr = DatePart("yyyy", Date) If CurYr Mod 4 = 0 Then me.AvgHrs=(Sum([CloseTime]-[OpenTime])_ *conLeapYrWks/conLeapYrDays)-(([CaysClsd]/ _ conLeapYrDays)*(Sum([CloseTime]- _ [OpenTime])*conLeapYrWks/conLeapYrDays)) Else me.AvgHrs=(Sum([CloseTime]-[OpenTime]) _ *conWksYr/conDaysYr)-(([DaysClsd]/ _ conDaysYr)*(Sum([CloseTime]- _ [OpenTime])*conWksYr/conDaysYr)) EndIF End Sub CloseTime, OpenTime are controlss on the fsub. DaysClsd is a control on the main form. Please let me know if I have explained this in sufficient detail. E Wilson

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) 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

Windows XP with Access 2002

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

Veja mais: 142857, m@sum, hrs, date calculation, php hrs, avg, day average access, face something software, calculation php form, access calculation, calculation access, sum day php, mod private, hrs work, engineering calculation, average detail form access, date calculation php, detail engineering, acc package, dim dim installation, dim dim php, day calculation code, access code average, php calculation average, php business day calculation

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

ID do Projeto: #3055824

Concedido a:


See private message.

$21.25 USD em 1 dia
(3 Comentários)

3 freelancers are bidding on average $18 for this job


See private message.

$21.25 USD em 1 dia
(8 Comentários)

See private message.

$12.75 USD em 1 dia
(2 Comentários)