subform footer

[kymay]

i am trying to place a text box in a subform footer that will total items from the detail section of my subform. when i place this text box in the footer section i cannot view it in form view nor will it print. what am i doing wrong?

 

[yessir]

even if it did appear, depending on the version of access, it prob just say #error as it will not be counted as part of the detail section.

suggest put at top or bottom of detail section

 

[Mile-O]

i am trying to place a text box in a subform footer that will total items from the detail section of my subform. when i place this text box in the footer section i cannot view it in form view nor will it print. what am i doing wrong?

What version of Access are you using? I've jut done it with A2002.

Things to check:

• Is the Form Footer's Visible property set to Yes?
• Have you set the form's Scrollbars property to Neither and the (sub)form doesn't fit the subform object?

 

[kymay]

i have changed these properties in the subform. i still can't see the box. however, if you can five me an easier solution that would be ok. what i need is to keep a running total and or have a box that totals up my amounts. i really don't care if it is even in the subform or if it is on the main form. just how can i get a total amout. i am using =sum([UnitPrice]*[quantity]). should i be writing something better? thanks again

 

[kymay]

version of access

i am using access 2002

oh and i am new here and kinda dumb

 

[kymay]

subform

if i place the box anywhere in the detail section, because it is in datasheet view, all the text box does in form view is add a column to the end of the datasheet. then i am back to needing to keep a running total. sorry i am sorry thick headed.

 

[Rich]

Textboxes in datasheet subform footers are not visible, change to a continuous form or add the datasheet to an unbound form and add a textbox to that form which references the subform footer textbox

 

[kymay]

much better

i now have a total box under each of my calculated boxes.
i am taking quantity x unit price=extended price. therefore, i want to keep a running total of the extended price or better yet just one total box. how do i do this?? again thank you i am nearly done!

 

[chancer1967]

Could we get a tutorial of form/subform totals in the FAQ? After trawling through several similar posts, this one solved my issue.