Recent content by access_new_bee

Agree ! I actually created a view out of the 'sub query' and used it in my query which made it all work. Thanks a lot for the quick responses everyone ! Appreciate it !

I did try creating the query in the 'ql view' in the 'query designer'. The error I posted was the one I was getting when I ran it in sql view.

I did make syntax changes when I copied to access.

Yeah I have tried the subquery thing, but still get the same error. I think creating a view in sql server and then linking it to access would be my 'goto' solution now, as the query runs perfectly fine in sql server. thanks for the quick response !!

Hi all, I get the below error when I try to run the below query in access. Query: SELECT dbo_MyWorkingResults.[Permit_Number],dbo_AffiliaSyntaxtegory.affiliate_category_id as 'AffiliateCategoryID' ,[AffiliateCategory] ,dbo_CollectionCategory.coll_cat_id as 'CollectionCategoryID'...