I'm trying to link two tables in Access...both tables contain the samefields with YTD totals.  I need to subtract YTD Total between the two,to determine the difference.  I have the tables linked via 2 fields.I group by the two fields, and sum on YTD.  It is multiplying thevalues and I'm ending up with numbers in the 200,000 instead of max ofabout 5,000.I've tried doing queries separately, doing the sum, and then linkingthe two new queries...only to have the same results.I've tried turning them into Make-Table Queries, creating the tablesand running the new query off of the 2 tables where the values havealready been summed.  Same results.In one off moment...it worked correctly.  The next time I went intothe Query again though, the numbers were off again.  I cannot figureout what I did differently.What am I doing wrong?  How do I achieve the correct results where thesum value is not multipled?Thanks

On 21 Mar 2007 19:54:16 -0700, "Ben" <bdicarlo1@yahoo.com> wrote:>What am I doing wrong?I don't know; what are you doing?Please post the SQL view of your queries. Sounds like your Joins arenonexistant or incorrect, but there's no way to tell from this distance!             John W. Vinson [MVP]