Hi Ladies and Gents, I have inserted a Microsoft Graph Chart in one of my reports, it is a bar chart and has over 70 possible classification for the data to...

Is it possible to do a SumIf calculation in an Access 2003 report (similar to what I can do in Excel)? For example, I have various values displayed in a...

My calculated field on the report is: =IIF(IsNull(),,) For SID, I want to format as 00\-000\-0000 For SEVIS, I want to format as L000\-000\-0000 How to do...

Is it possible to generate a report from controls from 2 separate queries. I have a query which shows the sum of grants year-to-date and another query...

I need to total check boxes. That I know how to do. My problem lies here. What I need to summarize are the boxes that are not checked. I have used...

I have set up a form frmCompany which allows users to select a company from a combo box cmbCompany and also enter in a datarage ie. txtStartDate and txtEndDate...

Hi, I have a table that has an estimated cost (Est £'s) and actual cost ( Actual Expense) fields. How do I get the report to calculate the difference please?

How do I break the link between labels and controls in Access 2007? When I use the Report Wizard and view in Design mode the lables and controls appear to be...

I'm looking to make a report that can be customized each time it's run. for example, my database tracks "stations" for each station there is a maintenance...

I have been asked to revamp a process of creating a 'report' that is currently taking days in Microsoft Word. At present, the document is hand-typed, images...

I am trying to Calculate a % on a Report in Access 2003 with the following formula: = / but I get a type mismatch error. What am I doing wrong. Can you...

Hi all, I am running Access 2003 on a Dell Optiplex with 1 gig of ram. I've constructed a complex database that does quite a lot. The VBA is either borrowed...

I have a report that contains sorting and grouping. In the detail section I have two textbox controls called "NETPROFMONTH" and "NETPROFYTD". In one of the...

I have a text control within my report header that I had to split into two because there were too many conditions on my If statement. Is there any way to...

I have a main report with 3 sub reports in it. Each sub report is based on a query. If there is no data on a particular person in one of the 3 subreport...

I have 2 fields I drag to the either the category area or filter area. They "Plant" and "Machine". When the user selects the "PLant" I want to filter the...

I am trying to sum from a text Box who's Control Source is a sum of an Expression that comes from the query. How can I do it?

Hi there, I have one main report and one subreport. In both queries i have in the date column the following criteria: Between And When i view the reports...

Hi Everyone, I want to create a report with the format as follows: PAGE 1 : MATERIAL CODE STYLEA STYLEB STYLEC ...

Hello, I have a field in my page footer called Duration. In the OnOpen event, I would like to test the value in that field. The OnOpen event has the...