Re: [AccessDevelopers] Query Help Please

[A.D.Tejpal]

Paul,       Could you please confirm whether it is your intention to find the overall sum for field named [Value], taking into account all records of first table combined with those of second table ?   Best wishes, A.D.Tejpal   ----- Original Message ----- From: Paul To: AccessDevelopers@yahoogroups.com Sent: Thursday, August 25, 2005 06:00 Subject: [AccessDevelopers] Query Help Please Hi I am just trying too add two tables together, have been out of using access for a while anyway to cut a long story short this is the query Expr1: [Card1_Value]![Value]+[Card2_Value]![Value] All I want too do is an Add sum not joint the columns together. Any help would be much appreciated thanks Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access database Microsoft access developer Microsoft access Microsoft access database design Microsoft access database training YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.