RE: [AccessDevelopers] Query Help Please

[Lava Boggavarapu]

Paul –   Try   SELECT Card1.Value + Card2.Value AS Total FROM Card1_Value AS Card1 INNER JOIN Card2_Value AS Card2 ON Card1.<common column> = Card2.<common column>       Lava   ------------------------------------------------ Lava Boggavarapu Lava Trading Inc. 95 Morton Street, 6th Floor New York, NY 10014 Tel 212.519.9371 Fax 212.519.9283 Mobile 732.668.2935 www.lavatrading.com -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Paul Sent: Wednesday, August 24, 2005 8:31 PM To: AccessDevelopers@yahoogroups.com 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 The information contained in this message and any attachments (the "Message") is intended for specific individual(s), and may be confidential or proprietary. If you are not the intended recipient, please notify the sender immediately, delete this Message and do not disclose. Messages are not secure or error free and can contain viruses and the sender is not liable for any of these occurrences. The sender reserves the right to monitor, record and retain Messages. Please zip all files prior to uploading to Files section. 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.