Sr. Torres I believe from previous discussions the this would be a duplication of information already obtained. I would just create a report and group either by salesperson and project or vice versa by project and salesperson. Do a summary on each grouping.
Glenn P. Jones Comm: 904 823-0653 -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of torres0157 Sent: Wednesday, 16 November, 2005 14:07 To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] creating a table while in a Form I have a Commision form that calculates commissions for various sales persons and I need to create information from this form onto a table. The fields I need are ssn, emptype, Commission Amt. The Commission Form will calculate the Commission Amt. The form will Allow 15 entries and the ssn could contain multiple entries because the commissions are paid by project. I would like to know if I am on the right track. I believe that I can create some code by using code builder on the Commission Amount field on the form (afterupdate). Me.What else................ can some one Help..... A.T. Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> 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/