From a command button on a form I have the following code to open a report: DoCmd.OpenReport "rptRouteMilesByTen", acViewPreview In the reports On Open code I...

I need to be able to check against a time value in conditional formatting so I can set the relevant field to bold. e.g. if "field" is greater than 3 hours,...

I am trying to print a report with information on alumni. Each page contains a profile for a former employee. It looks great. The only problem is that I am...

I have a report that needs to show the top 10 sales opportunities. I have it setup and it works fine as long as there are actually 10 opportunities that get...

Hello, I am new to Access and looking for some guidance. I am currently developping an application in which I can manage customers and the work I perform for...

Is there any way to pause and restart the printer from within access. My issue is an old lable printer (serial) that if I send more than 2 lables at a time it...

I need to create a report presenting data described in almost 20 charts. In addition to an executive summary, I want this one report to contain all of these...

I am making a check book which is printed out each week, I have a income field and a expense field. and a ballance field. the control is a querry with a...

I have 2 reports based on query's one query uses start date and end date, and the other has no date required. My report for start and end date works fine. My...

Is it possible for a report to pull information from 2 different query's. One query is by date and the other is not. Thanks for any help Roger

My report pulls sum from a query. Most totals are ok, but I need 1 which will change. If net Profit is less that $75000 I need it to calculate 20%...

I have put a sub report in the Page footer of another report. My problem is the sub report does not show the page header. In design view it shows, but when I...

I have a report where I would like to have a date in the header, The report pulls the data from a query with the following date criteria. Between...

I'm running a report where I have work orders. They are grouped by appr and comp. I need to create a report that will show all the appr tickets, but give...

How do I highlight a date if it falls on a weekend or holiday?

I have a database that was developed in Access 2000. We recently got some new computers with Office 2003 installed, but most of our machines still have Office...

I'm creating a report which originally has 10 fields in details. But it ends up with too many fields defined since lots of summary are needed. What I did is...

I have a report printing from a form that has two sub forms that are in data sheet format. When I send it to a report I would like to make the sub form info...

I have a report that contains three sub reports everything is working correctly as far as the output except the one page report repeats its self on a second...