Kiang- It is not recommended to store calculated values in your database. Why do you think you need this total in another table? What is the business problem you are trying to solve?
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of yong_yong6666 > Sent: Wednesday, August 03, 2005 12:16 PM > To: [email protected] > Subject: [ms_access] Code to duplicate a field data form one > table to another > > > I'm trying without success to automatically copy and paste a > field data > in my form to a another table field. Illustration as follows : > > Table A : > Key Field [Expend] > > Table B : > Key Field [Qty] > Key Field [Qty1] > Key Field [Qty2] > > Form is created from Table B with all fields of Table B included. > An addition unbound field viz. [Total] with expression : > =[Qty]+[Qty1]+ > [Qty2] has been added to sum up Qty. > A command Button has been created with intention, at click [Expend] > from Table A should = Me.Total > > In the event procedure, how should be written ? > > Many thanks for your help ! > > Regards > Kiang > > > > > > ------------------------ Yahoo! Groups Sponsor > --------------------~--> > <font face=arial size=-1><a > href="http://us.ard.yahoo.com/SIG=12hqhe48d/M=362131.6882499.7 > 825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123096576 > /A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org > ">Get Bzzzy! (real tools to help you find a job) Welcome to > the Sweet Life - brought to you by One Economy</a>.</font> > -------------------------------------------------------------- > ------~-> > > > Yahoo! Groups Links > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h1phe1g/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123098677/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> 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/
