Thanks Dwain. Very Nicely Done! This won't be the first time you've helped me. Perhaps one day I can repay you.

Also I checked the real table definition and the...

Very cool. Thanks Chris. Anything that improves efficiency at different levels is ideal. It's amazing how many ways there are to get the result set. I need to build access...

I like this idea of using the stuff function and delimiting the company's in the same column. I think with this and dwain's suggestion I'll be able to produce a...

Nice Dwain. This definitely works. I didn't think to use CROSS APPLY. Thanks for the post.

dwain.c (1/5/2014)

---

Ultimately, I believe you will need to aggregate twice. Once on User...

Thanks for the post dogramone but I am hoping to have only 1 record per company show in the result whereas this query returns the additional group id's. I could...

Thanks for posting WolfKillJ!

Your code worked really well. Correct me if I'm wrong about the logic behind it.

You create the CTE object to start. In each of the original...

I did originally try with union but I was running into an issue. I'll...

Yes that does make sense and I will try to create the code tonight. If I run into any problems I'll let you know.

Just what I needed. Thanks HanShi!

Dwain and Piet,

both of your suggestions work very well. thanks for the reply. I can't believe I missed your suggestion Piet. I was playing with a similar query and...

Wendel,

I am running access 2010. I have a column with datatype varbinary(max) in the sql server database. Based on the information you mention regarding the attachment control it looks...

Disregard my last message. I changed Me.DefectCategory to Me.Combo45.Column(1) and it worked.

Thanks for that idea.

Thanks for the reply Wendel. I did try your suggestion but received the error message Method or Data Member not found. I also attached a print screen.

do you think...

If using the Attachment object is an issue what is the recommended way to store image files on an Access form to a SqlServer 2008R2 backend?

Sorry for the false alarm. It was me being a fool. When I added the ODBC connection from access I was importing the data instead of choosing linking. Once I...