The actual query is/was:

SELECT

fld_3003 AS 'Contact'

,MAX(fld_4101) AS 'History'

,MAX(fld_3900) AS 'URL1'

,MAX(fld_3901) AS 'URL2'

,MAX(fld_3902) AS 'URL3'

FROM

cont_hist_t100

GROUP BY

'Contact'

Once I used just the actual column names and removed the "AS '...' " it worked!...

Appreciate the suggestion, but yes, on the actual table it throws an error:

"Each GROUP BY expression must contain at least one column that is not an outer reference"

My apologies. I was simply frustrated at a couple other forums while following their requests, and... no excuses, right?!

So is this what you are requesting (below)? I have...