I have designed a report based on a select query. I want all records on the report to print on one page, but no matter what grouping levels I choose, each...

Hi Folks I have a form, which has a subform-with an ImageBox (Image2). I load this up using the following code Me.Image2.Picture = gImageName Me.Image2.Width...

Hi There I have a report that lists many rows of Welsh3000 as either YES or NO. In the report footer I wish to total up all of the "YES". I have tried SUM...

Hi I have 1 report and a sub report they are both based on the same query.The query prompts the users to enter a value and then prints out the report.I have...

Is there a way to reset a running sum over all using VBA. I cannot use the overgroup function because I need to retain the value over several groups however I...

I have a report with grouping by the week. How do I get a date range to print as a header. If I put ww in a control box in the header I just get the week...

I am working for an engineering firm. I am doing my monthly billing by tracking time that each engineer spent on each project during the month. At the end of...

I have a fairly complicated report, based on a query. In the query, there is an expression which uses Switch to add words to some underlying data, depending...

I have a totals query that pulls out TotDaysVac and SumOfVac. I would only like to list the days on my report where TotDaysVac-SumOfVac =0 how do I do this??

I am trying to create a PivotChart in Access 2002 with 2 axis that each have a different scale. One that scales from 0 to 100 and the other that scales from 0...

Hi, How to show the name of the QUERY file at the footer of the report like the page number? TIA Ana

I am trying to output a report to a MS-DOS txt file. Not an option now that I am running Access 2003. Is there a work around maybe?

I have a report containing data on several different tax types. There are a dozen or more possilble type of tax. However, there are two types that make up...

Greetings, I have report 1. I have report 2 as a subreport in the report footer of report 1. I also have a text box in the report footer of report 1. Can I...

I have an MS Access reporting app that (was converted to v10 from v97 and ) when runs, a report of apprx. 75 pages that contains multiple chart objects on one...

I have created a report that has several calculated controls in it. I have been unable to get a total at any group level by any of the recommended =Sum()...

I wanted to know if anyone knows how to create a pivot table in Microsoft Excel by combining two seperate excel spreadsheets?

I am trying to apply a different color font to a control box. I can do that to the first control box using the "conditional formating". My problem is that in...

Greetings, I am running Access 2000. I have a report that I created with data source that is a query. What I need to do is print the output from a second...

I have a parent table named "Learn" with 2 fields; an autonumber field(pk) and a text field. I have a field called "Lrn" in a child table named "App" that...