Round up in a query

[Andï]

I have a query which subtracts (date and time out) from (date and time in), and I need to round up, so that a hire period of 1.4899 etc days would appear as 2 days.

Any ideas please?

Thank you.

a.poole at warwick dot ac dot uk

[Terry Kreft]

Where [amt] holds the data

IIf(Fix([amt])<[amt],Fix([amt])+1,[amt])

--
Terry Kreft
MVP Microsoft Access
"Andï" <a_dot_poole@warwick_dot_ac_dot_uk.ok> wrote in message
news:d1**********@wisteria.csv.warwick.ac.uk...
I have a query which subtracts (date and time out) from (date and time in),
and I need to round up, so that a hire period of 1.4899 etc days would
appear as 2 days.

Any ideas please?

Thank you.

a.poole at warwick dot ac dot uk