I seem to not be able to count the TOTAL
I have it counting PER the LCType but need in addition the total Issued.
but need it to summ a GrandTotal Count of LCType.
eg: I have 16 LCTypes and might have 50 of each type issued but can not sum this "50" for each type to arrive at a Grand total of say 1000 [LCTypes] issued.
I have tried "over Group", Over All in the Running Summ property of the field but does not summ it. I know it requires modification to the SQL but this is tricky for me as it is outside of the normal canned stuff in MSAccess.
here is the SQL:
AS SumOfamount, Count(tblLCTypeDropbox.lct
ype) AS CountOflctype, tblLCTypeDropbox.LCType, Sum(IIf([CurrencyID]=1,[Am
Rate]))) AS Sum1
FROM tblCurrencyExchange RIGHT JOIN (tblLetterOfCredit INNER JOIN tblLCTypeDropbox ON tblLetterOfCredit.LCType = tblLCTypeDropbox.ID)
cyID = tblLetterOfCredit.Currency
fIssueSB) Is Not Null) AND ((tblLetterOfCredit.Expire
dYN) Is Null))
GROUP BY tblLCTypeDropbox.LCType;