Change query for report, plus iif question

  • Thread starter Thread starter dw
  • Start date Start date
D

dw

Hi all. Is it possible to change the query underlying a report? We've added
a new field to the query, and it doesn't display it in the list of fields
available in the report. We'd hate to have to re-create our reports each
time a feild is added/deleted. From everything we know, that should work --
when the underlying query changes, the fields available to the report should
change, too. What are we doing wrong?

Also, we'd like to display a field (isTrained) that is True/False (-1/0) as
"Yes" and "No". We've tried this,

=iif(isTrained = True, "Yes","No")

but it doesn't do a thing. We tried changing it to say -1 instead of True,
but that gave an error. Thanks in advance.
 
To view the new field(s), you may have to view the Report properties and
select & build the Record Source. This should be a query that allows you to
drag new fields to the grid.

You should be able to simply set the Format property of a control bound to a
yes/no field to:
Format: Yes/No

When you state "gave an error", you should also state what the error was.
 
Thanks, Duane. Sorry for not including the error. We've stared at it so
much, we forgot others may not have seen it: "Data type mismatch in criteria
expression."
 
Did my suggestions help? Do you still need answers?
I'm not sure what would cause your error message. Is it possible that you
have null values in your field?
 
Back
Top