Howdy all,
Well here is the question, I have a Report that totals alot of Financial figures. It is based off a query that gets its criteria from a form ( Month, Year, Etc... ). The report works like a charm except one part. I have a Field that works fine if I put the criteria right in the query, but if I pull the criteria from a form I get #Error. Here is the field info.
=Nz(DSum("[Contractor_Repair_Cost]","qryAnuSubQPMRpt","[Participants]like 'CCR*' and [CreditTIN]=0 "),0)
there are actualy 6 of theses fields they use the same calulations just diferent query fields. Well any Ideas would be appreciated and thanks in advance.
Frank
Well here is the question, I have a Report that totals alot of Financial figures. It is based off a query that gets its criteria from a form ( Month, Year, Etc... ). The report works like a charm except one part. I have a Field that works fine if I put the criteria right in the query, but if I pull the criteria from a form I get #Error. Here is the field info.
=Nz(DSum("[Contractor_Repair_Cost]","qryAnuSubQPMRpt","[Participants]like 'CCR*' and [CreditTIN]=0 "),0)
there are actualy 6 of theses fields they use the same calulations just diferent query fields. Well any Ideas would be appreciated and thanks in advance.
Frank
