In Access 2007 I have a report where I would like to use a SQL statement inside a text box's control source. In the text boxes control source I copied the SQL...

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...

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...

I have the following in a text box field: =IIf( Is Null,"",Left(,1) & Mid(,InStr(1,,",")+2,1)) the field "Comp Entered By" is based off of a lookup table of...

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.

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, the default...

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 I open a...

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 has now...

Hi everyone It must be very simple for you guys but i can't find it: How to make a report, made of a query cross table, but only show records that the total...

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 and...

I have a report that uses one area to display either a percentage or a count I'd like to format the report field output so that if the value is less than 1...

I provide help with Access applications. I specialize in designing the tables for a new database and fixing problems and adding new functionality in existing...

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 column of...

Hi Team, I am desperately seeking help for a solution by which I would be able to merge the data for all records of any one field in a table to appear in the...

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 criteria I...

ola jordy

I have a page header section, a group header section, a group footer section and a page footer section on my report. The group header I am trying to use...

Hi All, I have a report whose record source is a query, the query consists of dynamic Select and Where clause and so the columns are user driven (based on...

If i have data in CSV file and it show like belwo Column1 Column2 ABCD Saturday ABCD Saturday EFGH ...

Apologies if this is a silly question. I'm trying to combine Lastname, Firstname Middlename in a report. I have =(+", "++" "+). The only time it works is if...