C
Chey
I have an unbound field in the footer of my report. The unboud field is
=Sum[Cash_Amount]
I have also tired
=Sum(Nz([Cash_Amount],0)
In my query I have the critiera
Not In (Select [Charge ID] From QRYAmount_Vendor_Date)
when I run the query if nothing falls in this critiera is says query to
complex.
What I would like is for the query to run and not state query to complex and
my unboud field to result in 0. Now if the query comes back and there is
information the whole process run fine. Including the query to complex does
not appear. Thanks for your help. I can also paste my SQL if that helps.
Thanks again
Chey
=Sum[Cash_Amount]
I have also tired
=Sum(Nz([Cash_Amount],0)
In my query I have the critiera
Not In (Select [Charge ID] From QRYAmount_Vendor_Date)
when I run the query if nothing falls in this critiera is says query to
complex.
What I would like is for the query to run and not state query to complex and
my unboud field to result in 0. Now if the query comes back and there is
information the whole process run fine. Including the query to complex does
not appear. Thanks for your help. I can also paste my SQL if that helps.
Thanks again
Chey