Calculate rate per hour

[RobJ]

I have hit a wall on a database that I have been working on, so far I have
two fields that are calculated from different queries [tothrday] [torearnday]

Employee day pay calculated by number of products at rate 1 + product2 at
rate 1 (i.e. 55.00)

Employee Day hours Calculated using the "On Time and How Much Has Elapsed"
script on, time in - time out - total breaks in hr:mm (i.e. 5:00)

I have been trying to calculate the rate, in my head as example above it is
easy £11/Hr but I can not get access to understand what query I want it to
calculate [torearnday] / [tothrday]= #Error

This is my first database so I have been guided by the help links within
access and a dummies book but can not find a solution, any help appreciated.

Cheers
Rob

 

[Jeff Boyce]

RobJ

I can't tell from your description what formula you are using to do the
calculation "in your head". If you were to write the formula down and pass
it to a clerk to do, how would it look?

Is that the "[torearnday] / [tothrday]= " that you described? Please post
the SQL of your query.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


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

 

[RobJ]

One query works out how much the employee earned in on day
Another works out how many hours:minutes they worked in a day
I want to work out the hourly rate of pay

So day 1
Earned £55
Worked for 5 hours
55 / 5 = 11 (£11/hr)

I believe the error is due to the hh:mm format of the time field

RobJ

I can't tell from your description what formula you are using to do the
calculation "in your head". If you were to write the formula down and pass
it to a clerk to do, how would it look?

Is that the "[torearnday] / [tothrday]= " that you described? Please post
the SQL of your query.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


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

I have hit a wall on a database that I have been working on, so far I have
two fields that are calculated from different queries [tothrday] [torearnday]

Employee day pay calculated by number of products at rate 1 + product2 at
rate 1 (i.e. 55.00)

Employee Day hours Calculated using the "On Time and How Much Has Elapsed"
script on, time in - time out - total breaks in hr:mm (i.e. 5:00)

I have been trying to calculate the rate, in my head as example above it is
easy £11/Hr but I can not get access to understand what query I want it to
calculate [torearnday] / [tothrday]= #Error

This is my first database so I have been guided by the help links within
access and a dummies book but can not find a solution, any help appreciated.

Cheers
Rob

 

[Jeff Boyce]

RobJ

We're not there. We can't see your fields. We can't see your query SQL.

If you want more specific suggestions, post more specific information.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


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

One query works out how much the employee earned in on day
Another works out how many hours:minutes they worked in a day
I want to work out the hourly rate of pay

So day 1
Earned £55
Worked for 5 hours
55 / 5 = 11 (£11/hr)

I believe the error is due to the hh:mm format of the time field

RobJ

I can't tell from your description what formula you are using to do the
calculation "in your head". If you were to write the formula down and pass
it to a clerk to do, how would it look?

Is that the "[torearnday] / [tothrday]= " that you described? Please post
the SQL of your query.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


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

I have hit a wall on a database that I have been working on, so far I have
two fields that are calculated from different queries [tothrday] [torearnday]

Employee day pay calculated by number of products at rate 1 + product2 at
rate 1 (i.e. 55.00)

Employee Day hours Calculated using the "On Time and How Much Has Elapsed"
script on, time in - time out - total breaks in hr:mm (i.e. 5:00)

I have been trying to calculate the rate, in my head as example above

it
is

easy £11/Hr but I can not get access to understand what query I want it to
calculate [torearnday] / [tothrday]= #Error

This is my first database so I have been guided by the help links within
access and a dummies book but can not find a solution, any help appreciated.

Cheers
Rob

 

[RobJ]

Hi Jeff,

Sorry I do not understand, I can email you the database but where do I find
the SQL?

I have found some code but that appears to be for the forms as VB code.

Rob

RobJ

We're not there. We can't see your fields. We can't see your query SQL.

If you want more specific suggestions, post more specific information.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


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

One query works out how much the employee earned in on day
Another works out how many hours:minutes they worked in a day
I want to work out the hourly rate of pay

So day 1
Earned £55
Worked for 5 hours
55 / 5 = 11 (£11/hr)

I believe the error is due to the hh:mm format of the time field

RobJ

I can't tell from your description what formula you are using to do the
calculation "in your head". If you were to write the formula down and pass
it to a clerk to do, how would it look?

Is that the "[torearnday] / [tothrday]= " that you described? Please post
the SQL of your query.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


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


I have hit a wall on a database that I have been working on, so far I have
two fields that are calculated from different queries [tothrday]
[torearnday]

Employee day pay calculated by number of products at rate 1 + product2 at
rate 1 (i.e. 55.00)

Employee Day hours Calculated using the "On Time and How Much Has Elapsed"
script on, time in - time out - total breaks in hr:mm (i.e. 5:00)

I have been trying to calculate the rate, in my head as example above it
is
easy £11/Hr but I can not get access to understand what query I want it to
calculate [torearnday] / [tothrday]= #Error

This is my first database so I have been guided by the help links within
access and a dummies book but can not find a solution, any help
appreciated.

Cheers
Rob

 

[BruceM]

Open the query. Click View > SQL.

It may help to edit a copy of the query in order to remove fields that are
not necessary to the problem at hand before you copy the SQL. I can't
really suggest anything to omit since I don't know any details of your
database.

Hi Jeff,

Sorry I do not understand, I can email you the database but where do I
find
the SQL?

I have found some code but that appears to be for the forms as VB code.

Rob

RobJ

We're not there. We can't see your fields. We can't see your query SQL.

If you want more specific suggestions, post more specific information.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


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

One query works out how much the employee earned in on day
Another works out how many hours:minutes they worked in a day
I want to work out the hourly rate of pay

So day 1
Earned £55
Worked for 5 hours
55 / 5 = 11 (£11/hr)

I believe the error is due to the hh:mm format of the time field



:

RobJ

I can't tell from your description what formula you are using to do
the
calculation "in your head". If you were to write the formula down
and pass
it to a clerk to do, how would it look?

Is that the "[torearnday] / [tothrday]= " that you described? Please post
the SQL of your query.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


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


I have hit a wall on a database that I have been working on, so far
I have
two fields that are calculated from different queries [tothrday]
[torearnday]

Employee day pay calculated by number of products at rate 1 +
product2 at
rate 1 (i.e. 55.00)

Employee Day hours Calculated using the "On Time and How Much Has Elapsed"
script on, time in - time out - total breaks in hr:mm (i.e. 5:00)

I have been trying to calculate the rate, in my head as example
above it
is
easy £11/Hr but I can not get access to understand what query I
want it to
calculate [torearnday] / [tothrday]= #Error

This is my first database so I have been guided by the help links within
access and a dummies book but can not find a solution, any help
appreciated.

Cheers
Rob