Search results

Hello, I'm trying to use Dlookup to find MICA_Grant Amount if Rank equal a number and Rank_code equal a code and the range between FM1 and FM2. Is this possible to do?

I have three fields in access query that I'm trying to sum. FallMICAStudentaid4Amount + SpringMICAStudentaid4Amount = TotalMICAStudentaid4Amount The two fields that I'm trying to sum are blank and will like to show 0 in total field.