Search results

well, it looks like the join type is a moot point. when I was rebuilding the query piece by piece, i happened upon the fact that the ContactID in tblActivity is blank. I thought I had mapped that already, but unfortunately I had missed that step. Sorry for wasting people's time, but I...

When I change all the joins to outer joins, it gives me a syntax error in the FROM clause on the Join type just as an edit, my goal is to have the report group on activity date and only return accounts for which some activity was performed.

Hi smarter people, I'm working on a light CRM database for work. I've set up the relationships and imported his data from an old DB we were using before and I have an issue that I've posed at a couple other places with some help, but the more ideas the better. I've attached the relationship...