I have a report with a large number of subreports. After each subreport in the detail section, I have a page break. In the code for the On Format event of...

Can you show me how to calculate a short time, i.e., 13:35, so that the result is 30 minute earlier; so it should show 13:05? Another example is: 13:05, the...

Hello, I have a table named, tbl_pt_records as shown below. ID AdmitDate EndDate AdType Place Comments NH 1*01 4/15/2009 4/27/2009 ...

I have created a report with multiple lines of data that could be null. I set the fields to "can shrink." It does shrink the line and move it up a field but...

Hi I need to insert rounded rectangles on an access report. To see what I mean, open Paint, and selected rounded rectangles from the toolbox. These rectangles...

I have a report based off a query that has started to fail. I have a copy of my database from 4-27 where it works and another copy from 4-28 where I've...

Hi I need to create a count at the end of my report that tells me how many occurances of a certain value appear in the report. e.g. Report field of "Issue"....

Thanks for reading this. I have a report that is grouped by in a two column report. It prints out ok. The thing is what I want it to do is when a new comes...

in Access 2007 I some report fields that are to display quantities and amounts the range of these numbers could be large (100,000 or $345,999) or small (0.375...

I am using the DoCmd.OutputTo command in Access 2007 to output reports in PDF format. is it possible to make this command append to an already existing PDF...

Hello, I have a report that populates a field in the header from a report parameter. This parameter field is a date which is used in the query to pick up all...

I would like to print a red,yellow or green flag based on the value of another field. I'd like to use the flags in the Excel 2007 icon set. Is there a way to...

I have built a invoicing system and am tring to build a report that will print a field in the page header depending of if a condition is satisfied in th detail...

Hello All i must be blind, stupid or dumb. i cannot find how to change the centimeters that Access 2007 is currently using to be Inches. i have looked all...

Access 07 on WinXP Have used report wizard to create basic reports. Want to move the data labels in the headers independently of the data field. really want...

Hi. I have an Access 2007 database. I would like to know the best way to setup the report so I can easily export the information into a word table. (Perhaps...

I cant seem to activate horizontal or vertical position control in report design unlike Access 2003 -- henry

I have two problems when printing reports. 1. By providing separate print preview and print command buttons on a form, it is simple to preview or print reports...

I tried John's suggestion and it works. I'm using Office 2000 and Access 2000. First, Tools, Office Links, Publish it with MS Word. Then in Word highlight...

For Access 2003 I have a report that gives employee attendance information. There is no report header. I want to set up printing so that, if needed, it...