#error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We all know that the report will return #error from a query with no data. Is it possibe to print the query parameters (i.e. start and end dates,and a customer name) in a report with not data so that users know that the reason for no data is not due to a typo in the input parameters? Thanks!
 
10317 said:
We all know that the report will return #error from a query with no data. Is it possibe to print the query parameters (i.e. start and end dates,and a customer name) in a report with not data so that users know that the reason for no data is not due to a typo in the input parameters? Thanks!
Click to expand...


In a main report, you can use text boxes that refer to the
**exact** parameters used in the query. E.g. if a parameter
is a reference to a text box on a form:

one report text box might have:
="Customer: " & Forms!myform.txtcustomername
or, if the query uses prompt strings for its parameters,
another report text box could have:
=[Start Date] & " to " & [End Date]
 
Back
Top