Hello,
I am trying to write a query that puts invoice amounts in columns, by invoice, named "Jan", "Feb", "Mar", etc. based on the right two characters of a "Period to Post" field. When I do this, the results are erroneously excluding amounts that are identical even though I have Unique Values and Unique Records set to "No". For example, if I have four charges for postage of $0.44 each in February, the query is only returning $0.44 once. Here is the syntax that I've used for each month:
Jan: IIf(Right([GL Quick Query].[Period to Post],2)="01",[Debit Amount],0)
Feb: IIf(Right([GL Quick Query].[Period to Post],2)="02",[Debit Amount],0)
Mar: IIf(Right([GL Quick Query].[Period to Post],2)="03",[Debit Amount],0)
I do have my query set up as a "Sum" (sorry, but I don't know the right terminology here) using "Group By" as the Total function. I thought this might be why I was having trouble but when I set it up without a "Sum", and used "unique values", I'm finding the same result. I am not experienced at all with Access and was hoping that someone might be able to help. Thanks.