Convert query results from hours to days

[embdenb]

Hi

I am the admin of a small database. It is an access front end with a sql back end.
I have created a query in design view to export information from a specific table. In one column the results between opening and closing a work order is shown in hours. Can I insert a criteria to show that column in days?


Thanks

 

[PHV]

Divide the number of hours by 24.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[embdenb]

Divide the number of hours by 24.


I am a novice at this. What do I put in the "criteria"?

 

[PHV]

No criteria, but in the field cell:
NumberOfDays: [your hours column]/24

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[embdenb]

No criteria, but in the field cell:
NumberOfDays: [your hours column]/24


I decided to just add a column to the excel output and put in a formula in the cell.


Thanks again

 

[SkipVought]

Same result. However, if number or rows returned changes when your run this query again, you will have to adjust the formula to the returned number of rows in Excel, so it really would be less maintenance to add this column to your query.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}