Forum Discussion
Solved
Values Change in Append
I am wondering if anyone has come across this before. We have 4 seperate databases that are all setup with the same table structure. I am pulling from the data for general ledger transactions from ea...
My apologies for the delay in response here. I was on vacation when you asked the question and the email was lost in my inbox until now. I did solve this purely by luck. It appears that if you have conflicting privacy levels (and sometimes even not) the append will give different results. I turned off the following option in my reports and things stablized:
File=> Options and Settings => Options=> Privacy
From there I chose the other radio button option "Ignore the Privacy Levels and potentially improve performance".
Yes. I added the same order by to all 4 queries. How many columns are you selecting in yours? Did you order by all of them?
I just ordered by one column. Not really sure why it worked for me - sorry you didn’t have the same luck