IIf works in query but not in report Utf 0 304
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]=...

Invalid Sheet Name on Export Utf 1 469
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 ho...

First Letter of each word Utf 1 629
I have the following in a text box field: =IIf([Comp Entered By] Is Null,"",Left([Comp Entered By],1) & Mid([Comp Entered By],InStr(1,[Comp Enter...

Crosstab Graph Report not showing Parameters in text box Utf 3 304
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 grap...

Automatically name a report when exporting to PDF shm135 1 547
Hello, I have a form with a command button that opens my report in print preview mode in Access 2007. When I click the Export to PDF/XPS button, ...

stLinkcriteria no longer working (since 2007 upgrade) arathra 1 324
We have just upgraded to 2007 and are having a few minor problems. I've seen similar threads online but can't find the solution exactly for us. If...

PageSetup properties keep changing PayeDoc 2 319
Hello All I recently had some mdb corruption problems, that I THINK I've solved - by creating a new mdb and importing all objects. A new problem h...

easiest way to create gridlines in an Access 2003 report Utf 1 359
Does anyone know an easy way to create gridlines in an Access 2003 report so that it resembles a spreadsheet, other than manually drawing vertical a...

Trying to calculate difference between two times in an access repo Utf 2 844
I am trying to calculate the difference between two times in an access report and don't know what the correct expression is. My report has a colu...

Access report date problem. Utf 1 242
I have created a lot of graphs to show various information. The problem I'm having is that I need the graphs to show the last 14 days of data. The ...