I am working with a report based on an MS Access query in which 2
fields are IIF/Then statements. The fields I want to sum are stating
values calculated in the query, and I want totals by group and a grand
total {=Sum([field])} for these two items. However, I keep getting an
error message that says to use another aggregate function besides SUM
because I'm working with a text field.
I'm working with MS Access 97.
You've helped me before...any help you can give me on this will be very
much appreciated!
Diane Cummins
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
PCSOFT mailing list is brought to you by:
The NOSPIN Group
http://nospin.com
|