How do I calculate an average per hour field in an Access report?



I have a field that calculates how much time a job took, and a field that
shows how much is being paid for that job. I would like to create a field
that shows the average per hour that was made on that job. I beleive the
problem is that I am trying to divide a currency data type by a time data
type. Is this possible to do.
Thanks for any help, I'm very new at using MS Access. I'm using the 2002



Larry Linson

As you haven't said what data you have and how you are keeping it, it would
be really difficult to make a suggestion. If your "suspicion" is true, then
that would be a problem.

If you have a start time and an end time for the work, you should be using
the DateDiff function to calculate the actual time worked, and that result
would be in a Single or Double. The Date/Time field or variable is for
recording a point in time, like 05/16/2005 08:49:16, not for recording a
number of hours (you'd want a variable that can have both an integral and
fractional part, like a Single or Double Floating Point, to hold the hours
and fractions thereof).

Larry Linson
Microsoft Access MVP



Duane Hookom

You can divide a currency (which is a number) by a time (which is a number).
If you are using a date/time data type, you need understand that in
date/time values are stored in parts of days. .5 equals 12 hours.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question