In the design view of the query put the bring the two fields down to the grid. On the tool bar at the top there is a Totals button that looks like a greek "E". Click that. Both fields will have a new line under them that says "Group By". Go to this line and select Sum instead of Group By for the qty field. Then run the query.
May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ----- Original Message ---- From: muhamed_faisal2000 <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, October 16, 2006 12:07:23 AM Subject: [ms_access] help pls Dears , I want to make a query in which it should add record in the same field name For example I have a table like this Production name Prodn qty Abc 40 Abc 40 xyz 40 Now I want to make a query that show me total sum of prdn name with prodn qty Here the sample result as per my expectation Production name Prodn qty Abc 80 xyz 40 Hope any body can help me with this matter Thanks Muhamed Faisal N [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
