Greetings! My first post to this site, so let's see how it goes!!
I have made a report in access that does some math, but having an issue running a sum of a column that math is in. Here is the scoop.....
I have a text box labled txtQTY, (keeps track of total number of parts used), and another text box named txtPrice (Price of that part). I made a column that displays the total price amount (txtTotalToDate), with the following math
=[txtQTY]*[txtPrice]
That works fine, but now here comes the porblem....I want to make a text box in the footer to display the total of all items (which is the total price of all txtTotalToDate boxes). So i made a txt box in the footer called txtAll and I did this...
=Sum([txtTotalToDate])
...but when I run the report, I get a message box that says "Enter Parameter value. txtTotalToDate." After hitting OK, my txtAll box displays nothing.
Any suggestions?
I have made a report in access that does some math, but having an issue running a sum of a column that math is in. Here is the scoop.....
I have a text box labled txtQTY, (keeps track of total number of parts used), and another text box named txtPrice (Price of that part). I made a column that displays the total price amount (txtTotalToDate), with the following math
=[txtQTY]*[txtPrice]
That works fine, but now here comes the porblem....I want to make a text box in the footer to display the total of all items (which is the total price of all txtTotalToDate boxes). So i made a txt box in the footer called txtAll and I did this...
=Sum([txtTotalToDate])
...but when I run the report, I get a message box that says "Enter Parameter value. txtTotalToDate." After hitting OK, my txtAll box displays nothing.
Any suggestions?