All, I am creating a quotation system within Access 2007 and wish to create a report to print the quote in PDF format. I need the report to be about 3 A4 pages long to enable a cover page, details page and a costings page. having started to create the report, I have come across the 22 inch limit. Can...

Hi All, I‘m creating a chart report through the report wizard. I have a date field and three other fields with numerical data. In the process of creating the chart I get the following error All data fields must be summarized (using Sum, Avg, Min, Max or Count) when a date field is used in the axis or...

HI, I have a form based on a query with a listbox. I would like to have a user select a item in the list box click a button and a report open only showing the related record details for the item selected in the listbox. The listbox returns the primary key value but displays text. I created a blank form...

Experts, I am stuck and I am looking for help. I have been working with access for a few years now, and the VBA behind it. However, I can't seem to figure this problem out. I know how to filter an access report when it is displayed using: DoCmd.OpenReport stDocName, acPreview, , strFilter and I know...

I'm working with a poorly designed table that saves a text string into a field defined as an OLE Object. It's a "legacy" table and cannot be changed. I need to display this field in a report but of course the field doesn't display properly. Can anyone offer any help or advice to...

Hi, Using reporting service 2005 to produce reports but cant seem to find a way to prevent the report on running on page load. I want the end user to press the view button before the report returns Thx in advance

I am currently working on building a facility managment solution for my office to use in which I have a building table which contain address, city, zip, police, fire, etc for each building and also a complex table which I have a multi select combobox with the buildings id and name to "add"...

Hello, I have a table like this: Table A ------- Cust_Code Job_Code Dept_Code 01 JOB1 A 02 JOB2 A 03 JOB3 B 04 JOB4 B 05 JOB2 A 06 JOB3 A ... ... ... I have a crosstab query that count how many customer belongs to a particular job code for a particular dept, like this: Query A ------- Dept_Code Job_Code...

Hello I need to hide or display a textbox(or label or rectangle) on an XP access report. the report is linked to a query and the query has a field blnWrap. In the detail section of the report I want to hide or display a field called txtCover depending on whether the clnWrap field is true or not. I dont...

I'm trying to create an Access report that will include a 13 page Word document at the end of each customer's statement. (I can't format it properly in Access.) I don't want to write the data to a Word document using Automation as I want to use Access's ability to expand or shrink...