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.