Control Source help

[roger751]

Can anyone link me to a site that has examples of control source expressions? I've created a db with several reports that sum up total number of parts but because I used the Yes/No format in my table, all the yes's equal -1 and I have negative numbers that I want displayed as positives.

Please help

Thanks

btw, Im using Access 2K3

 

[Rich]

=Sum(Abs([YourField]))

 

[roger751]

Great...Thanks alot. Just what I wanted.