combine to sum fields into one on access report

[eric.l.bohon]

ALCON,

What i am trying to do is combine two sum fields into one on a report. I did it before but now i can not remember how i did it. here it is

report I have two sum fields

=sum([asgn])
=sum([auth])

this is what I am trying to do

=sum([asgn]) & " of " & ([auth])

I get this

22 of 1 instead of 22 of 25

any help on this.

 

[jeffreybrown]

Try....

=Sum([asgn]) & " of " & Sum([auth])