Hello,
I could use some help with a statement that is giving me an error because it exists in both tables that I'm using. The field is "Period to Post" and the statement that I'm trying to use is:
IIf(Right([Period to Post],2)="01",IIf([Debit Amount]=0,-[Credit Amount],[Debit Amount]),0) AS Jan
The table names are "PSJ" and "GL Quick Query". I've tried using "[GL Quick Query].[Period to Post]" but that doesn't seem to work. I've also tried renaming "Period to Post" to just "Period" with "SELECT DISTINCT [GL Quick Query].[Period to Post] AS Period" at the start of my statement and then changing "Period to Post" to just "Period" in the above statement but that doesn't work either. Any suggestions would be greatly appreciated. Thanks.