I was wondering if anyone can help me or guide me? I have created a BAQ to pull data based on AttrCodes and SalesRep Codes but it’s not showing all of the data.
CustID: CHANWALL will not show up but has the same settings as CustID: AGARSCAR which shows up without any issues.
I have looked at Customer Entry and every tab is the same? Anything I’m missing?
I often switch the join types to ensure I am getting the proper set of results. If you switch the joins for the top level query to ‘all rows from Customer’ it might give you the results you want. This just makes things a bit less restrictive. But be careful, it can give you more results than you want if your criteria is not set properly.