Am using the following in reports to identify various categories, based upon an accumulated total: =Switch((-Sum(*24))="40","super",(-Sum(*24))="24"...

I'm trying to display an Access 2000 report total on the same page as the list of numbers being totalled. But Access is not allowing me to do this, insisting...

I need to run a report that is bound to a table where some fields have several different values. I need to put controls in the report that would give me a...

When I run a report with the printer not attached or offline I need to get an error message so that I can redirect thatprinter elsewhere. Right now when I run...

I find it hard to believe that we don't have a way to check the status of a printer in Access before we send the report there. Shouldn't this be easy to do in...

?? I'm using ACCESS program. It provides me MAX, MIN, AVG,... but not Median function..?? How to get Median from ACCESS?

I'm not verry good with acess this is a project i inherited and i learned for this project only. It manages only 3 tables but they are large and...

Hello, I don' understand why creating subreports from a pass-through query is impossible. The reports I am trying to create are very basic. The only turn...

I have created a form to allow my users to scroll through their selected customers and view a PivotChart of customer data. The PivotChart is housed in a...

I'm trying to Round Up and Round Down the decimal results on an access report. Is anything available to allow me to do this? I know that it is available in...

I am using access database, creating a report, and in the report using a chart. The x-scale is date/time, and I want to be able to use a variable for min and...

Good Day all, I have an invoice report that I export upon printing to .snp format, but I am getting the following error when trying to export. Access goes to...

I am opening 2 reports on the press of one button on a form. The problem I have is how to handle things if either of the reports has no data. Using On NoData...

Hello. I have a report to construct in which one of the fields is to display all the services our company provides to the client. A continuous form is used...

Hi, I have alot of Blank pages when i print out my Reaports, is there a way I can delete them or aviod having them in my Report? Thanks, Tatum

Hi, I am facing a very strange problem with Access Reports. I have got a form in which there are several fields . I created a Report inorder to display all...

The situation is that I need to create a report that shows montly values for 9 different locations. I ran the query wizard to calculate the value for each of...

What is the function which can convert date field to string in a specific format? Thanks.

Am attempting to use conditional expressions that may result in multiple responses based on the result of expression "=-Int(-Sum(*24))" in a report. i.e. if...

I've create a simple record based to a query with a Total Field to summarize my expenses. The record work with a range of date. If in the range of the date no...