If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Total in Footer
Hello,
I'm new to access and have a question regarding the footer. I created a text box and inserted a basic equation for the the total cost of the order, =Sum( [UnitPrice]*[Quantity]), however it is not appearing on the form. The visibility property on the footer is set to Yes. Please let me know what I am missing - Thanks - |
#2
|
|||
|
|||
Total in Footer
On Mon, 26 Apr 2010 19:58:53 GMT, "TheLee" u59624@uwe wrote:
Hello, I'm new to access and have a question regarding the footer. I created a text box and inserted a basic equation for the the total cost of the order, =Sum( [UnitPrice]*[Quantity]), however it is not appearing on the form. The visibility property on the footer is set to Yes. Please let me know what I am missing - Thanks - This should work on the Form Footer, but will not work on a Page Footer. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Total in Footer
I got it to work by using a Continuous Form. Is this feature available on the
other form types? Just curious because this type will work. I was using a Datasheet Form. Thanks - John W. Vinson wrote: Hello, I'm new to access and have a question regarding the footer. I created a text [quoted text clipped - 5 lines] Thanks - This should work on the Form Footer, but will not work on a Page Footer. |
#4
|
|||
|
|||
Total in Footer
On Mon, 26 Apr 2010 20:43:34 GMT, "TheLee" u59624@uwe wrote:
I got it to work by using a Continuous Form. Is this feature available on the other form types? Just curious because this type will work. I was using a Datasheet Form. That's one of the many limitations of Datasheets: no header, no footer. A Single Form has both (but a total could be confusing since you'ld see only one record). -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|