I know that in forms, I can just use a text field and add up numbers in other text fields. Reports seem to be different. I need to add up fields, but it won't use the code: =sum(txtFemale)+(txtMale) in the Control Source. I got that information from using the DLookup from some queries. So, I decided to use those queries and add them up with the DLookup: =Sum((DLookUp("SumOfSexCount","qryStatSexCombined4 ","Sex='Female'"))+(DLookUp("SumOfSexCount","qrySt atSexCombined4","Sex='Male'")))
That just gave me an error.