Hi!
I have a field in my table named BusinessHours which is formatted as Date/Time - Short Date. I need to be able to count the number of records in my table where the BusinessHours field is <= 4. When I run this query I do get a result however the result is incorrect; it is counting too many records.
This is what I have currently:
Code:
SELECT Count([tbl_HomeOwner Claims].Claim) AS CountOfClaim, Count(IIf([tbl_HomeOwner Claims]![BusinessHours]<=4,[Claim])) AS [Contact Less Than 4], [Contact Less Than 4]/[CountOfClaim] AS [Percent Less Than 5]
FROM [tbl_HomeOwner Claims];
I have tried quotation marks but I get an Data type mismatch error. In another query I used <= 4 AM to show me the claims that are less than 4 hours and that worked but when I try to use something like that in this aggregate query I get an error.
Thank you for any help you can provide!