Hello everyone, my first post in the Access forum. Using Access 2013. Only been using Access for the last month.
I have a Payment Receipt report that contains a column called Type which would be either Cash or Check and another column called Total , which is the cost of the product.
Right now I just have a sum in the footer that sums up all the monies in the Total column. I want to have a separate total for both Cash and Check and then have a grand total of the monies received. So the totals in the footer would be: if Type = Cash , it would then sum the Totals of Cash, and if Check it would sum the totals of Check.
I found a formula on the web,
Code:
sum(Iif([Type]="Cash",[Total],0)
but received this error Syntax Error in Query Expression Firstsum(Iif([Type]="Cash",[Total],0).
Appreciate any help or suggestions,
Thanks
Mike