I am using XP-Pro and access 2003. I have used the sum function before but for some reason it will not work. I put the following in a text field on a form. Sum= ([name of column]) but now I get an error that you can see on the attachment.
I am using XP-Pro and access 2003. I have used the sum function before but for some reason it will not work. I put the following in a text field on a form. Sum= ([name of column]) but now I get an error that you can see on the attachment.
Try
=Sum([name of column])
This works fine. Thank you very much. I knew there was something that I did wrong.