Re: #Error Message in Report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You can use a control source like:

=IIf([HasData], Sum(Qty),Null)

--
Duane Hookom
MS Access MVP

"RMP" <u25421@uwe> wrote in message news:64ea9040d756a@xxxxxx
The query parameters correctly return no records. The report that is run
based on this query returns #Error in the report controls.
What is syntax to use so that when the query correctly returns no records
a
Zero is displayed in the report instead of #Error.
Thank you for your help on this.



.

Relevant Pages

  • ControlSource error message
    ... Following query works. ... But when I paste as a control source of a text box on a form, it gives me error message: "check the subquery's syntax and enclose the subquery in parentheses". ...
    (microsoft.public.access.gettingstarted)
  • Troubles with control sourrce for a text box
    ... I am trying to set the control source of an unbound textbox on a form. ... used the following syntax: ... RPfeedbackPART1 is a Query and Med is one of his fields. ...
    (microsoft.public.access.forms)
  • #Error Message in Report
    ... The query parameters correctly return no records. ... The report that is run ... based on this query returns #Error in the report controls. ... What is syntax to use so that when the query correctly returns no records a ...
    (microsoft.public.access.reports)
  • Re: Nested IIF Statements
    ... I generally prefer to have expressions in a query rather than in the ... expression is in the control source rather than in the query. ... Yes, my form is based on a table and Sales, Short, and Long are fields ... Or maybe you would need to use the Nz function, as the calculation ...
    (microsoft.public.access.forms)
  • Re: Changing the parameters of a form
    ... need to store the Working Days. ... the query should return what you want. ... I am using the form so that a user can simply select a StartDate and EndDate ... just put Available in the Control Source text box. ...
    (microsoft.public.access.queries)