Reports

Showing Totals from Subreport on Main Report
I have a main report with 3 subreports and I want to display totals from each subreport and grand totals in the report header of the main report. What is the best way to do this? Allen Browne posted the following response to a user back in 2003 offering a method. But, I can't get the [rptInvoiceDogs].[Report... 17 Jul 2008 12:42

How do I print multiple copies of the same record on labels?
I have this same problem. I want to take the qty field and print that qty of labels Is there a way to repeat the label the amt of times the qty? "Richard D" wrote: It does not seem that Ben replied to your question, I will: I am storing the number in my record. The field name is "OQUAN". The quantity... 15 Jul 2008 15:25

Creating a report from a query that is driven by a combo box
HI all. I have just used http://www.fontstuff.com/access/acctut08.htm#top to vreate a query where a drop down list created in a form is used to select the correct data. The next bit I need to do is to create a report. The only problem is that when I create the report I get a wierd dialogue box and not th... 15 Jul 2008 11:16

Data in report won't display correctly
Hello, I believe you have provided a solution to my chart problem with the code listed below, (Problem - the plotted data does not show in the chart when printed, converted to pdf.file, or using snapshot) I want to verify how to write the code when I have 3 different charts. Do I create a new title for eac... 16 Jul 2008 17:11

chart on report
I would like to set visible and invisible the charts on the report base on conditions. It seems Access still running the query in the background when I set report invisible. Are there any way to stop Access to run the query when the chart is invisible? Your informaiton is great appreciated, ... 15 Jul 2008 10:14

Report for Counting orders keyed
I have to generate a report counting numbers of orders keyed by associates and numbers of lines keyed. (There may be multiple lines on one order). I need a formula to count only the unique records in the order number column. for instance: Operator Order Number Line Number JSMITH 123456 ... 15 Jul 2008 10:14

Capturing email address from a sent report
Hi all, I was wondering if anyone had any solutions on how to you can capture an email address from a report you send with outlook. I have a report that has a macro that sends it to a single address. I want to capture who the report is send to before it is sent. is there anyway to do this? thank so much, Angel ... 15 Jul 2008 16:27

null value
Access02 have need for a conditionally visible label in group header & footer OnFormat. have made it into a text box and put into the control: =IIf(IsNull([Name]),"Testing"," ") Not working. Sanity tested this: =IIf(([Name]<>"test"),"Testing"," ") and this works Sanity tested this =IIf(([Name]=""... 16 Jul 2008 03:45

output reports to a single text file
attempting this in Access97 as that is what I have to work with - trying to output report(s) that are created by users to a single text file that accumulates the data. The report is not based on a query, and it has 2 subreports. The users 'update' the table record(s) as needed via 3 input forms I created, then pr... 15 Jul 2008 09:12

Reducing font size according to textbox content ?
Hello ! With Access 2000, i have a report which displays a person name and adress, to be printed on very small adhesive labels, so that the maximum size of the report is fixed. Sometimes, the member name and adress is very big so that the whole text is not displayed within the textbox. I would like to decrease ... 15 Jul 2008 11:16