Now that I've got this stupid database working the way I wanted it, does anyone know a good way to replace hair pulled in frustration?
Thank you all for the help.
Thankyou Trevor for the good link.
I have it working now.
Ron Bell, after viewing Trevor's link, I understand what you were trying to tell me. Thank you.
Thanks Chris,Richie and David, I do have a space in the field name and I tried the [] with no success. Therein lies my trouble, I'm not sure what other type of aggregate function to use in order to get the same results.
The text boxes are located in the footer.
I'm still learning Access 97 and I could really use some help.
I have two columns; unit price and total price and I need to get a running total at the bottom of each column.
I've read a couple of Access books and they suggest using =Sum([Unit Price]) but I have not been able to make this...