Calculating time in query

[R. Mahler]

Hi there,

I'm searching for some help with my query. I'm making access to be my
administration program for my freelance job. I've made a table with a row
'starttime' and a row 'endtime'. Now in my query I want to calculate the
difference between these two rows. And then I want to make another query to
calculate the totals of these differences. Is this a logic way to do this?
And I'm trying to make a expression to calculate the difference but with no
luck. The result is something like this: 3,2515785. I've found a kb article
but I still can't figure it out because I don't know how to use VB.

I hope someone can help me with the expression and can judge if above is a
logic thing...

Thanks in advance!

Roy

 

[Brendan Reynolds]

Hi there,

I'm searching for some help with my query. I'm making access to be my
administration program for my freelance job. I've made a table with a row
'starttime' and a row 'endtime'. Now in my query I want to calculate the
difference between these two rows. And then I want to make another query
to calculate the totals of these differences. Is this a logic way to do
this? And I'm trying to make a expression to calculate the difference but
with no luck. The result is something like this: 3,2515785. I've found a
kb article but I still can't figure it out because I don't know how to use
VB.

I hope someone can help me with the expression and can judge if above is a
logic thing...

Thanks in advance!

Roy

There are several articles on working with dates and times in Access at the
following URL ...

http://www.mvps.org/access/datetime/index.html

 

[Jeff Boyce]

It all starts with the data (design) in Access.

How is it that you have one row holding (something's) [starttime] and a
different row holding (?that same something's?) [endtime]? Wouldn't start
and end times be related to the same something?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[R. Mahler]

This table has a field with a unic ID, a field with a menu linked to a
project table so that a can pick the name of the project, a field for the
starttime, a field for the endtime and a commence field. And I thought that
a can make the calculating in the query.

Hope a bit clearer

Roy

It all starts with the data (design) in Access.

How is it that you have one row holding (something's) [starttime] and a
different row holding (?that same something's?) [endtime]? Wouldn't start
and end times be related to the same something?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Hi there,

I'm searching for some help with my query. I'm making access to be my
administration program for my freelance job. I've made a table with a row
'starttime' and a row 'endtime'. Now in my query I want to calculate the
difference between these two rows. And then I want to make another query to
calculate the totals of these differences. Is this a logic way to do
this?
And I'm trying to make a expression to calculate the difference but with no
luck. The result is something like this: 3,2515785. I've found a kb article
but I still can't figure it out because I don't know how to use VB.

I hope someone can help me with the expression and can judge if above is
a
logic thing...

Thanks in advance!

Roy

 

[Jeff Boyce]

Your original post mentioned calculating the difference between two rows.
This description sounds like you want to calculate the difference between
two fields. Check the lead that Brendon provided.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

This table has a field with a unic ID, a field with a menu linked to a
project table so that a can pick the name of the project, a field for the
starttime, a field for the endtime and a commence field. And I thought that
a can make the calculating in the query.

Hope a bit clearer

Roy


"Jeff Boyce" <[email protected]_HYPHEN_TO_END> schreef in bericht

It all starts with the data (design) in Access.

How is it that you have one row holding (something's) [starttime] and a
different row holding (?that same something's?) [endtime]? Wouldn't start
and end times be related to the same something?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Hi there,

I'm searching for some help with my query. I'm making access to be my
administration program for my freelance job. I've made a table with a row
'starttime' and a row 'endtime'. Now in my query I want to calculate the
difference between these two rows. And then I want to make another

query
to

calculate the totals of these differences. Is this a logic way to do
this?
And I'm trying to make a expression to calculate the difference but

with
no

luck. The result is something like this: 3,2515785. I've found a kb article
but I still can't figure it out because I don't know how to use VB.

I hope someone can help me with the expression and can judge if above is
a
logic thing...

Thanks in advance!

Roy

 

[R. Mahler]

Hi Jeff,

Thanks for you reply. I can't find the lead of Brendon? Is it in this
group?

Greetz

Roy

Your original post mentioned calculating the difference between two rows.
This description sounds like you want to calculate the difference between
two fields. Check the lead that Brendon provided.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

This table has a field with a unic ID, a field with a menu linked to a
project table so that a can pick the name of the project, a field for
the
starttime, a field for the endtime and a commence field. And I thought that
a can make the calculating in the query.

Hope a bit clearer

Roy


"Jeff Boyce" <[email protected]_HYPHEN_TO_END> schreef in bericht

It all starts with the data (design) in Access.

How is it that you have one row holding (something's) [starttime] and a
different row holding (?that same something's?) [endtime]? Wouldn't start
and end times be related to the same something?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Hi there,

I'm searching for some help with my query. I'm making access to be my
administration program for my freelance job. I've made a table with a row
'starttime' and a row 'endtime'. Now in my query I want to calculate the
difference between these two rows. And then I want to make another query
to
calculate the totals of these differences. Is this a logic way to do
this?
And I'm trying to make a expression to calculate the difference but with
no
luck. The result is something like this: 3,2515785. I've found a kb
article
but I still can't figure it out because I don't know how to use VB.

I hope someone can help me with the expression and can judge if above is
a
logic thing...

Thanks in advance!

Roy

 

[John Spencer]

Brendan Reynold responded to your posting.


There are several articles on working with dates and times in Access at the
following URL ...

http://www.mvps.org/access/datetime/index.html

--
Brendan Reynolds

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Hi Jeff,

Thanks for you reply. I can't find the lead of Brendon? Is it in this
group?

Greetz

Roy

Your original post mentioned calculating the difference between two rows.
This description sounds like you want to calculate the difference between
two fields. Check the lead that Brendon provided.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

This table has a field with a unic ID, a field with a menu linked to a
project table so that a can pick the name of the project, a field for
the
starttime, a field for the endtime and a commence field. And I thought that
a can make the calculating in the query.

Hope a bit clearer

Roy


"Jeff Boyce" <[email protected]_HYPHEN_TO_END> schreef in bericht
It all starts with the data (design) in Access.

How is it that you have one row holding (something's) [starttime] and
a
different row holding (?that same something's?) [endtime]? Wouldn't start
and end times be related to the same something?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Hi there,

I'm searching for some help with my query. I'm making access to be my
administration program for my freelance job. I've made a table with a row
'starttime' and a row 'endtime'. Now in my query I want to calculate the
difference between these two rows. And then I want to make another query
to
calculate the totals of these differences. Is this a logic way to do
this?
And I'm trying to make a expression to calculate the difference but with
no
luck. The result is something like this: 3,2515785. I've found a kb
article
but I still can't figure it out because I don't know how to use VB.

I hope someone can help me with the expression and can judge if above is
a
logic thing...

Thanks in advance!

Roy