IIf works in query but not in report0460 (6/7/2010 10:30:37 PM) Does the IIf function work differently in queries from the way it works in
reports?
For example, this works in a query:
lastName: IIf([Last]="Smith",Null,([Last]))
(I can hid the last name "Smith" i... Utf
Group totals in dynamic report3405 (4/26/2010 8:05:01 PM) I have a report that dynamically gets control source for five columns based
on user input through a form. The report successfully shows text boxes
(currency format) with approporiate fields (control source)... Utf
Crosstab Graph Report not showing Parameters in text box3507 (6/7/2010 5:30:42 PM) I have a report using a crosstab query in a graph. The query is asking for
parameters. When I try to pass the parameters to a text box on the graph
they will not pass through. I am building it in text bo... Utf
Force the group footer to print on the first page9224 (5/27/2010 8:55:36 PM) Hello,
Does anyone know how to force the group footer to print only on the first
page of an Access 2007 Report?
Thank you in advance.
... Utf
Invalid Sheet Name on Export1765 (6/7/2010 6:36:59 PM) When I export a report from Access to Excel via DoCmd.OutputTo I get an error
from Excel saying Invalid Sheet Name. What can be causing this and how I do
to keep this error from happening?
... Utf