Percentages in query

[Noreene Patrick]

I have a query that I want to figure efficiency on employees based on time logged in and actual minutes worked.

My query pulls in data from 2 other queries where I have summed by ID the (1) minutes worked and the (2) minutes logged in.

So, the new query has as its fields, employeeid, sumoftotaltimelogged and sumofacutalminutes. My calculation field looks like this:

Efficiency: format([sumofactualminutes]\[sumoftotaltimelogged], "percent")

It returns a value but it is rounded off to 200% or 100%. I have deleted everything in my tables (trial data) and changed every number field to single, did the same thing and changed to double and it still either rounds it to the nearest hundred or gives me 0%.

I am tired of trying to figure this out on my own!!!!

Could it have something to do with the way I have my field set in the login and logout times? They are set to long date to capture hours and minutes. Then the query does a datedif("n", [dateloggedin], [dateloggedout])?

Thanks for any help.
Noreene

 

[Noreene Patrick]

Okay, I think I have found the problem, maybe.

In each query that I did and that I made a field that was calculated (expression) for (1)sumofactualminutes and (2) sumoftotaltimelogged, these 2 fields are rounding the number..but since it is a calculated field, how do I get it to show as a double field type? I tried to format it in the query by rightclicking and going to format and giving it fixed, then general and even standard format. But, I get the same results.

I saw this when I tried to make a report and use an unbound txtbox to calculate the efficiency....Then I realized the reason the percentage is rounded is because the totals of both calculated fields are rounded.....DUH!!!!

But, since time is involved, I really dont know what to do.

Thanks,