Sum of Fields

[UT227]

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.

[Gicu]

Have you looked at using dCount (or dSum depending on your query) instead of dLookup?

Cheers,
Vlad

[UT227]

I did not. I'm not familiar with the dSum. Can you give an example of it?

[UT227]

I guessed on it. I came up with: =DSum("SumOfSexCount","qryStatSexCombined4")
It seems to work.

[Gicu]

Great, glad to hear! If you think this issue is now solved please mark it accordingly.

Cheers,
Vlad