J
Jim Johnson
Hello,
I have a table that processes both credits and invoices, as needed, using
the same form. Now I need to create a monthly report that shows the total
credits and total invoices by product.
I tried to use an IF statement that would total all records with credits (if
the credit checkbox was selected) and would total the invoices for all
records with the invoice checkbox selected. This did not give me an error
but does not give me a value. Please see the respective calculations below:
=IIf([CreditRequest]="Yes",Sum([Quantity]*[Unit Price]),"")
=IIf([InvoiceRequest]="Yes",Sum([Quantity]*[Unit Price]),"")
The following formula will give me a total, by product, of both together but
they need to be displayed separately.
=Sum([Quantity]*[Unit Price])
What am I doing wrong? Can someone please help me to make this work?
Thanks,
Jim
I have a table that processes both credits and invoices, as needed, using
the same form. Now I need to create a monthly report that shows the total
credits and total invoices by product.
I tried to use an IF statement that would total all records with credits (if
the credit checkbox was selected) and would total the invoices for all
records with the invoice checkbox selected. This did not give me an error
but does not give me a value. Please see the respective calculations below:
=IIf([CreditRequest]="Yes",Sum([Quantity]*[Unit Price]),"")
=IIf([InvoiceRequest]="Yes",Sum([Quantity]*[Unit Price]),"")
The following formula will give me a total, by product, of both together but
they need to be displayed separately.
=Sum([Quantity]*[Unit Price])
What am I doing wrong? Can someone please help me to make this work?
Thanks,
Jim