Times in queries

[nevstic]

Hi there everyone
Would someone have the answer to this please

I have a query and a calcualted field called
TIM[tim2]-[tim1])

In Tim1 I have 11:00 and in Tim2 I have 12:0

When I run the query I get Like 0.04838382828

Can I show the result to be 1 (as I can in Reports)

Thanks
best rgds
Nick

 

[bdmclennan]

Nick,

Try this:
TIM: datediff("h",[TIM1],[TIM2])

Cheers

B.

 

[nevstic]

many thanks your quick reply "B"

works a treat !

Regards
Nick