I give up GPF2^....

I looked at my dictionary of slangs & no yield.....I must've led a very sheltered life....so what are crayons ?!?! Enlighten me!

???? ne comprends pas!

Fallen Angel - give me some time (work always interferes)...the table b part of your query looks like it should be:

SELECT Region, Company, Department, SUM(Q1) Q1, SUM(Q2) Q2, SUM(Q3) Q3...

Okay - then Scott's response makes everything clear!!!

Hey Frank - good to see your post even if you've surfaced for just this one...let us know how it goes with the beer!

huh?!?!

Gogula - happy b'day!

okay - agree about totally ridiculous...when did you last eat crayons?! Any particular colour ?! I personally went for white chalk....yum!

And since I must be true to my gender...

what steve jones holiday parade....oh - you mean the one each year on the 4th of July in this here great land where the buffaloes roam ???

would it help...

You know - you hit the jackpot when you said - "I vote for Steve Jones"...that was simple and direct and appealed to the man despite his blatant solicitation...

Stop fishing GPF^192 - you already have the shirt!

ps:Nirvana without sitting under a tree....UNHEARD OF! Shortcuts do not apply....

I'm not sure what is required -

it seems like you should be able to make do with "select * from tableA cross join tableB" ("I wanted every region, company,...

It should be something like this:

Select A.* from tblMediaAssets A

inner join

(select max(MediaAssetID) MediaAssetID from tblMediaAssets

Group By ArticleID) B

on

A.MediaAssetID= B.MediaAssetID

Order By A.MediaAssetID

Let me know if it works!

Tarique...couple of things:

1) Your objectID is not useful at all...you should use docID, AddressID etc. since this is the only ID that uniquely identifies your rows.

2) From what I can...

Tarique..."selects a record to modify, i will get the ID of the record they chose. uisng this ID i will get the necessary information...."

- which column in your address...

Are we not allowed to have more than one favourite...let's not narrow our horizons...