How to add a number of cells in a form?

[brainst0rm]

Another newbie question
I have a form in which I can put an indefinite number of rows, and in each row I will put a value. I want to add ALL of this values (I don't know how much are them) and have the result in a textbox.

Thanks. Diego.

 

[boblarson]

If you are using it in DataSheet mode, you can't do it. But, if you are using it in continous mode, you can put a text box in the footer and use

=Sum([YourFieldNameHere])

(keeping the brackets)

 

[brainst0rm]

If you are using it in DataSheet mode, you can't do it. But, if you are using it in continous mode, you can put a text box in the footer and use

=Sum([YourFieldNameHere])

(keeping the brackets)

I don't know which are the differences between that types, but here a screenshot

I'd like to have the total of 10.95 in the Order Subtotal.

 

[brainst0rm]

If you are using it in DataSheet mode, you can't do it. But, if you are using it in continous mode, you can put a text box in the footer and use

=Sum([YourFieldNameHere])

(keeping the brackets)

I understand now that the form IS in datasheet mode; I really cannot have the sum of the cells? Can I change the the mode of the subform?

Thanks again for all. Diego.

 

[brainst0rm]

up

 

[neileg]

Don't use datasheet mode. You can do anything in continuous mode that you can do in datasheet mode and a whole lot more besides. Don't try and fix a problem that simply disappears by changing mode.

 

[brainst0rm]

Which type of mode I can use to have a similar layout in the subform?

 

[brainst0rm]

I cannot find a solution, someone has ideas?

Thanks.

 

[neileg]

Which type of mode I can use to have a similar layout in the subform?

Continuous. Try switching the mode in the subform properties, but you may have to create a new subform. The form wizard will create a continuous form if you opt for the tabular format.

 

[brainst0rm]

I'm really going crazy with this; if I switch the mode in continuos, it change the appereance and I need a layout to the datasheet mode. If I try to build a new subform, the wizard doesn't allow to set the tabular type (actually, I cannot set any type...).

EDIT: I manage to get the subform in continuos mode and to look like a datasheet mode. The problem is that the "Order Subtotal" doesn't update...

 

[neileg]

You can build the subform as a separate form and then drag and drop it on to your main form.

If you post a stripped out version of the database, some kind soul may help you out...

 

[brainst0rm]

Here the file I'm working with. I hope some angel can help me

Download

 

[neileg]

Sorry, that site is blocked by our firewall. Can you post it as an attachment here?

 

[brainst0rm]

The forum doesn't allow me to upload so large files (5 mb). Can you tell me another site?

 

[neileg]

The forum doesn't allow me to upload so large files (5 mb).

Have you stripped out most of the data, and forms and reports not relevant to the question and done a compact and repair?

Can you tell me another site?

Not that I can read from.

 

[brainst0rm]

Ok, done. Here the database.

 

[neileg]

Quick and dirty but it works.

 

[brainst0rm]

Thanks for your time, but the order subtotal doesn't work...

 

[neileg]

Oops, got the formula wrong. Change it to
=Nz(Sum(([Quantity]*[UnitPrice])-([Quantity]*[UnitPrice]*[Discount])))

 

[brainst0rm]

Oops, got the formula wrong. Change it to
=Nz(Sum(([Quantity]*[UnitPrice])-([Quantity]*[UnitPrice]*[Discount])))

Man, you saved my life!!! That's great!! It works now!!!