IIf([Prepaid],"Prepay",IIf([Receipts].[DowntownCash],"DCR",IIf([PaymentTypes].[PaymentType]="Cash","Cash",IIf([Receipts].[Mailin] And ([HeadOffice]=True),"Mail","Non")))) AS PmtType
This is the full SELECT line- I'm trying to understand what conditions makes the PMTTYPE field/variable (I'm not a app guy)
SELECT DISTINCTROW IIf(IsNull(MailinSource.MailinSourceID),"No Source Entered",Trim(Trim(Str([SourceNo])) & " " & [Description])) AS SourceDesc, MailinSource.Description, Val(Trim(Trim(Str([SourceNo])) & " " & [Description])) AS ValDesc, IIf([Prepaid],"Prepay",IIf([Receipts].[DowntownCash],"DCR",IIf([PaymentTypes].[PaymentType]="Cash","Cash",IIf([Receipts].[Mailin] And ([HeadOffice]=True),"Mail","Non")))) AS PmtType, Sum(([ReceiptsID]<=CLng(nz([RelatedReceipt],[ReceiptsID])))*-1) AS ReceiptCount, Sum(Receipts.ServiceCharge) AS SumOfServiceCharge, Receipts.MailinSourceID, Sum(IIf([DowntownCash],[AmountSubmitted],[TotalTax])) AS Expected, Locations.Location, Locations.LocationID
2007-02-05
00:42:12
·
3 answers
·
asked by
justaguyaskingaquestion
1
in
Programming & Design