ERROR in Sum(Field1) in footer of continous form
Posted on 2006-04-13
Hi. I have a simple continuous form that contains several fields from a query as well as a few textboxes that do some calculations. On my computer these fields Sum fine in the footer. However, when I roll the program to the clients computer, when I try to do a summary in the form footer, all I get is the #Error showing up. I am just using a textbox with =sum(field1) on it. I have a sum field for both the calculation textboxes and one of the bound fields. I just can't understand why it's working on my system and not on the clients. Any suggestions as to what I am missing? Thanks!