J
JMS
I am trying to setup a very basic report with a Query from the Order Entry
database template. I am trying to get my report to show a gross total for
each order including freight and sales tax. I have the net amount being
generated by: Net Order Total:
Sum(CLng(nz([Quantity]*[UnitPrice]*(1-[Discount]))*100)/100) and the sales
tax amount being generated by: Sales Tax Total:
Sum(CLng(nz([Quantity]*[UnitPrice]*[SalesTaxRate])*(1-[Discount])*100)/100)
which seems to be working okay. I am not sure what is needed to add those
two dollar amounts and display them in a Gross Order Total. The Total Sale
field in the Orders by Customer form has the amount that I am trying to get
myreport to generate. Any help you might be able to provide would be very
much appreciated. Thanks in advance.
database template. I am trying to get my report to show a gross total for
each order including freight and sales tax. I have the net amount being
generated by: Net Order Total:
Sum(CLng(nz([Quantity]*[UnitPrice]*(1-[Discount]))*100)/100) and the sales
tax amount being generated by: Sales Tax Total:
Sum(CLng(nz([Quantity]*[UnitPrice]*[SalesTaxRate])*(1-[Discount])*100)/100)
which seems to be working okay. I am not sure what is needed to add those
two dollar amounts and display them in a Gross Order Total. The Total Sale
field in the Orders by Customer form has the amount that I am trying to get
myreport to generate. Any help you might be able to provide would be very
much appreciated. Thanks in advance.