Okay I must ask this first why would you want this said field in the table. When you can calculate that value via a Query at any point in time that you need it. The reason I ask is because generally totals are not stored if you plan on storing the individual items that make up that total. It's redundant data.
--- lilyviata <[EMAIL PROTECTED]> wrote: > How can I have a calculated field in a table? > for instance... > > group expenses1 expenses2 totalexpenses > A $2 $4 $6 > > where the totalexpenses field is > [expenses1] + [expenses2] > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Protect your PC from spy ware with award winning anti spy technology. It's free. http://us.click.yahoo.com/97bhrC/LGxNAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
