Subform line total to Table

[johnnybwis]

I have a subform in data sheet view that gets a total using


=[Subtotal]*[UnitsReceived]
in the control source

But I need this information to go to the table field unit
weight

How would I do this?

 

[Junior1544]

I think this is a normalization problem...

Here's a question... why does that number need to be stored?? why not just leave it in an unbound field and have that as the control source... then if you need it in a report do the same...

here's another question... if you get more (of what ever this is[UnitsReceived]) then the number you stored is now wrong...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[johnnybwis]

Ok I did leave it and do have a report that now does the
calculation. I don't understand why a change in [Subtotal] ([UnitsReceived] cannot change) would be a problem, it should change in the table just as [Subtotal] would. Sorry but I do not know what a nomilization problem is.
Thanks for the response

 

[Junior1544]

on this form do a search for Normalization.

When you get the responce look through the posts and or FAQ's... when a database is normalized it makes the database run faster, and it makes it much easier to do things... less code and more flexability...

to store that number you need code to store the number, then code to pull the number out... instead of that one line of a control source...

According to data normalization, you never store a calculated field... you don't do that because if one of the source data fields changes, you now don't have the correct answer and need to recalculate... instead of just not storing it and having the computer produce it on the fly when needed...

--James

junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[johnnybwis]

I check out the FAQ and understand better but now have a
new question on my report. I do the calculation on the report with text box statement.

=[UnitsReceived]*[Subtotal]

but now need to do a total on that field so I inserted another text box in the footer with

=Sum([Text53])

but do not get results on report, what do I now need to do

 

[Junior1544]

I think this question should go in a new post... that way some one with better report knoldge then me can help you...


also, I would suggest posting that in the following forum...

forum703 junior1544@jmjpc.net
Life is change. To deny change is to deny life.