Help in Forms

J

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..
 
J

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.
 
J

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
Click to expand...
[quoted text clipped - 10 lines]
Click to expand...
 
Top