Reports

Unbound Calculation populates from 3 seperate fields
Hope someone can help me solve this...I really need some help, I have tried and read alot and can not find the answer I am looking for. I am trying to get this expression to work in my database. I have 3 fields QC%, InBound% and 3rd Party% that have percentages. using a bound field: ( I have used IIF and NZ to... 26 May 2010 10:16

Label Report
I have a situation where I need to create labels from a table. The table is ClassEntries. Fields include: BackNumber ClassNumber RiderName Sample Data: Back# Class# Rider 1 2 Brianna White 9 2 Kira Kaseloo 12 2 Jennifer Batts 23 2 Claudia Coombs 24 2 Christina Boucher 29 2 Kennedy Seeley 39 2... 25 May 2010 22:22

Total is off by a couple of cents
I have a report that feeds of a query. The query has the following fields matsales: [order details]!unitprice*[order details]!quantity scharge: [order details]!surcharge*[order details]!quantity Taxes: ([matsales]+[scharge])*0.0875 0.0875 is that tax values On the report the sum in the footer =Sum(matsales) ... 4 Jun 2010 12:34

simple textbox data source syntax question
Would someone please take a look over my shoulder? I've got the following code entered as the data source for a text box on a report; but even in it's simplest state, returns #error# the intent of the code is to truncate the text at it's first hard return =mid([CatalogNoMod],1,nz(instr(1,[CatalogNoMod],chr(1... 25 May 2010 14:40

Hyperlink to Page number in Report that is exported to PDF
I am using the Inittoc() function to generate a Table of Contents from a source report. In addition, I am using Leban's ReporttoPDF code to auto generate the PDF, with both the Table of Contents report and source report combined. This all works. I would really like the Table of Contents page numbers to hyperlin... 26 May 2010 15:50

How stop duplicate fields when creating a Report in Access?
no metter what method I use to create the report - it throws double fields into the report. You manually delete one of each and proceed and it continues to add double fields. We did not have this issue in 2003 version. WHat is the problem and how do we fix it? ... 28 May 2010 12:40

Report footer position
Can anyone help how to get a report footer to print at the BOTTOM of the last page of the report, not just where the detail of the report happens to end? Or is there a facility for having a different page footer for the last page of the report? Or what? I am using Access 07. Many thanks to anyone willing to... 27 May 2010 17:04

Open report to current year
I have a form with a combo box for the user to select criteria to open a report. The following code works but I want to add the criteria that the records displayed only the current year not all years. Any help will be appreciated. Private Sub cmdListCodes_Click() Dim strFilter As String Dim varItem As Varian... 25 May 2010 00:31

Subtotals
I just found this posting - I apologize for the late response. The sorting & grouping in the report is as follows: SalesOrderID Openlineitem ItemNo ProductID The detail in the report is: itemorder SOTransactionID Shipdate UnitsOrdered UnitsShipped OpenLineItem price SubtotalSO and the footer is ... 24 May 2010 23:27

Using VBA to hide a report's detail section?
Hi, I am using Access 2007. I have created a report with a detail section and some summary information in the group header. Sometimes I want to see the detail section, but other times I would like the detail section to be hidden so that I only get the summary info. Can anyone tell me if there is a relativel... 24 May 2010 17:57