IIf works in query but not in report 0 460 (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 report 3 405 (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 box 3 507 (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 page 9 224 (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 Export 1 765 (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