I have a report which contains a number of sub reports. When I try to run the report it askes, intermittently, for a filed that I know I'm not using. How can...

Is there any way to merge two seperate reports in MS Access? I have two reports that I want to make into one report and then print. I can not use the...

Hi, I REALLY like and appreciate how much more flexible and faster it is to create professional reports in Access 2007 compared with Excel, but (there's...

=Trim( & " & " & ) If Owner2LastName fields is null, how do I make the & not show up on the report? Please help.

I am having some issue with this but not sure what it is. I am guessing the Columns2 variant is not being created for one reason or another but have not...

I am helping someone with a new database. He is not Access savvy and he wants to be able to select report criteria from drop down menus as he runs the report....

I have a NameField that has duplicates. I want to include a total of the names on my report, but only count the duplicates once. ...

I have a Billing system that ouputs a Bill and a Word Document. Within the Word Document, I need to insert verbiage for the categories selected on the Bill....

I have a report and it has a count at the end in a group footer. Not all of the groups will have a value. Can Access calculate the ones that should have a...

Hi all, I have table (tblmetircs) that stores metrics for agents. I want to create a form based on tblmetrics that a user can update by adding comments in a...

Good afternoon, I am new to Access and have a tool that contains a report linked to a single query. The items in the data are sorted by type and by class. ...

Hi, In access, I would like a report to run that would pull information from a query, which works fine. This report will in fact be a contract. I have a...

Hi there! Using A02 on XP. Have a report that I would like to have printed on it "There is no data for this report" rather than have the message appear in the...

I output a textbox with =Format($,"mmm yyyy") which works fine, and has for several years, under a computer running XP but under under Vista it interprets...

I know that this subject has been explained extensively in the forum but I have searched and cannot find a solution to my specific problem. I have used the...

I actually have two questions: I'm trying to print a label(s) in Access and would like to be able to print "1 of 2", "2 of 2" etc on the bottom of each label....

Odd behavior... two of us open the same database, and preview the same report,(not at the same time), on two different computers.... when he previews it, he...

I have a report with multiple groupings. What I need is to keep the groups from splitting across pages. I can't do a section page break, as I do want more...

I'm trying to total an aggregate function in a report. Here's the basics. UnitIn- UnitOut - Yield - WtYield 10100 - 10000 - 99.01% - 90.01% 2000 - 1000 - 50%...

Is there a way to know how a report is being sorted and what kind of formatting it has using the properties sheet? The report is not running (has an error)...