Works like a charm...don't really know what I was actually thinking...

Smooth.....I think it will work once I fix the fact that I wrote one database using the normal "Danish_Norwegian_CI_AS" while for some reason they have the 2nd in "Finnish_Swedish_CI_AS". ...

Yes,not completely clear but I guess "download" because the do have a trial from what I remember. So IMHO not shady but not clear/well planned. And the price...

Strange, I sent to http://www.sqltreeo.com/wp/ and was shown prices for month, year and lifetime before entering anything. The prices were in Euro, maybe because they know I...

"All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it."

Love it!!!!

No, my bad. I think I saw you are in the UK and I am in Oslo so I was more cafinated than you were at the time, in...

Got it. Well you did....I took your code from above and added back the GROUP BY a.Country that we mistakenly omitted in the form. This is obvious from...

Thanks...but same as before.....I am going to leave work now...bring my PC from work and probably look at it with a clearer head.

I'll keep you posted.

Cheers,

Dave

I was just going to write that I changed it when I saw it....it is all a blur now....but I get the same error thing about the '('....maybe UNION ALL...

Oh...and thanks for your help....forgot to say it...not in a good mood right now about this MS Query. I will let you know either the fix or when I...

One was called CountryName on one sheet and Country on the other (they come from two different systems) so I renamed the column to CountryName on both.

Tried:

select a.CountryName, Sum(a.amt) as...

Got it (what you mean) but still getting the "Could not add table '('".....which means there is something maybe slightly off in syntax. I have worked a very ugly...

It will definately work on sheets when written with brackets and a...

Hate to bring up MS Query again but the "boss" has a rule that I cannot even use access for a quarterly report that only one user will ever use...but...I...

Actually looking better in the past weeks from the e-mails but here is one example from a few weeks ago:

Here's a few of the new posts today on the forums....