Alexander Willey
Registered User.
- Local time
- Today, 03:11
- Joined
- Mar 1, 2013
- Messages
- 31
Dear Forum,
I have the following fields in an access query and I expected the calculated field HoursUsedOnContract to display the value of 2.75, but it is giving 0 instead. Please can you advise what I could be doing wrong?
OpenedTime = 31/08/2018 15:28:53
ContractStart = 01/09/2017
ContractEnd = 31/08/2018
TimeUsedInHours = 2.75
HoursUsedOnContract: IIf(([OpenedTime]>=[ContractStart]) And ([OpenedTime]<=[ContractEnd]),[TimeUsedInHours],0)
Thank you for any help
I have the following fields in an access query and I expected the calculated field HoursUsedOnContract to display the value of 2.75, but it is giving 0 instead. Please can you advise what I could be doing wrong?
OpenedTime = 31/08/2018 15:28:53
ContractStart = 01/09/2017
ContractEnd = 31/08/2018
TimeUsedInHours = 2.75
HoursUsedOnContract: IIf(([OpenedTime]>=[ContractStart]) And ([OpenedTime]<=[ContractEnd]),[TimeUsedInHours],0)
Thank you for any help