It's hard to tell without seeing your table structure. A couple of comments.
WHERE (((tblfileinspect.caseapr) Is Not Null And (tblfileinspect.caseapr)>1) AND ((tblfileinspect.ffdate) Between Date() And Date()-90))
Well, if you have
tblfileinspect.caseapr > 1
you don't need
tblfileinspect.caseapr Is Not Null
because the first requirement will ensure that the field is not null. Also, you used a BETWEEN in your criterion but your dates are backwards. I wonder what Access will do if your end date is AFTER your start date. Swap those.
tblfileinspect.ffdate Between DateAdd("d", -90, Date()) And Date()
Say, there are balloons and confetti coming off the ceiling. Oh, this is my 1000th post.
Michigan Dept. of Environmental Quality, Air Quality Division