Em Andamento

SUM of time values

I am trying to read an undifined number of Time values from an access database and display the sum of all the value read.

Basically, I'm writing a small db app (using an access 2k backend) that will log time spent on an activity (a log book). Each record will have a Start Time and a Finish Time and an Elapsed Time (using the method in my first post. What I'm trying to get to is the total time spent across all entries. There may only be 20 entries in the database but then there may be 100's.

I have had a go and my testing app is in the ZIP file. The problems with my app so far are

This line: -

Total = [url removed, login to view](GetTimeSpan(CDate(dr("START")), CDate(dr("STOP"))))

Generates this exception: -

[url removed, login to view]: Object reference not set to an instance of an object.

The exception MsgBox does appear the "correct" number of times and then Total is displayed as 00:00:00 instead of 30:00:00.

Russ

## Deliverables

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

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

.NET

Habilidades: .NET, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, Visual Basic

Ver mais: work values, what are work values, first form of writing, dr first, log time, writing my first book, start writing a book, book writing app, time record, m@sum, nullreferenceexception, access database problems, app platform backend, small basic app, testing access database, read log app, small program visual basic net, net access backend, source code finish net, php read file writing, source code book app, activity log access, access log activity, system using visual basic access, form backend log

Acerca do Empregador:
( 12 comentários ) United Kingdom

ID do Projeto: #3055341

Premiar a:

aspxwarriorvw

See private message.

$7 USD em 5 dias
(7 Avaliações)
0.8

7 freelancers estão ofertando em média $39 para este trabalho

TakeRealUK

See private message.

$17 USD in 5 dias
(554 Comentários)
6.7
kdz13

See private message.

$49.3 USD in 5 dias
(74 Comentários)
6.3
s2010vw

See private message.

$17 USD in 5 dias
(8 Comentários)
5.6
yitzsl

See private message.

$12.75 USD in 5 dias
(7 Comentários)
4.6
sjhatchard

See private message.

$6.8 USD in 5 dias
(6 Comentários)
2.7
ysfred4

See private message.

$12.75 USD in 5 dias
(1 Comentário)
2.5
siteware

See private message.

$170 USD in 5 dias
(0 Comentários)
0.0