theDBGuy,
Thank you. With a clear head this morning I read your post above. Your suggestion to utilize data in the table helped with two of my issues (one Max and one Min).
I changed the below formula
MaxVCRatio: IIf([VCRatio]>0,(SELECT Max([VCRatio]) FROM qryRank1),0)
to the formula...