G
Guest
I created query name Total Amount query. In this query I am calculating
total for each order. The last column in this query is Total_Amount then to
get all totals I put the following code in field row for this column:
Total_Amount:nz([Cash1])+nz([Certified_Check])+nz([Company_Check])+nz([Credit_Card])+nz([On_Pickup])+nz([On_Delivery])-nz([Prepaid])+nz([Origination_Fee])+nz([Gratuity])
The record source for this report is based on different query that I named
Query 1. I would like to place totals to that report however if I set
control source for text box Total Amount on that report to =[Total Amount
Query]!Total_Amount I am receiving an error message. How do I place totals
on that report? Thanks
total for each order. The last column in this query is Total_Amount then to
get all totals I put the following code in field row for this column:
Total_Amount:nz([Cash1])+nz([Certified_Check])+nz([Company_Check])+nz([Credit_Card])+nz([On_Pickup])+nz([On_Delivery])-nz([Prepaid])+nz([Origination_Fee])+nz([Gratuity])
The record source for this report is based on different query that I named
Query 1. I would like to place totals to that report however if I set
control source for text box Total Amount on that report to =[Total Amount
Query]!Total_Amount I am receiving an error message. How do I place totals
on that report? Thanks