Help in Forms

[jtidwell]

I have a mess.... I had to do a lot of expressions in my queries... no none
of that information is stored in my tables... I done calcalations in
subforms.... and those totals will not show in my queries or tables..

 

[jahoobob via AccessMonster.com]

If you want the calculations to show up in a query and a form, do the
calculations in the query. The calculated field can be displayed in the form
just as any table/query field. You can display a forms calcualtion in a
query but it is a little more work to do so. You should not generally store
calculated fields in a table. As many experts on this forum/newgroup will
tell you, Tables are for storing data..queries, forms, and reports are for
viewing and manipulating the data.

 

[jtidwell]

How do I take a calculation I done in subform and put it in a query.

 

[jahoobob via AccessMonster.com]

You don't!. The calcualtions will not show up in a query but you don't need
(or want) them to as you will see the results everytime you view a record in
the form with the calculations.

How do I take a calculation I done in subform and put it in a query.

If you want the calculations to show up in a query and a form, do the
calculations in the query. The calculated field can be displayed in the

[quoted text clipped - 10 lines]