Recent content by Kage

For some reason, this issue was driving me crazy...so I came home and tried again with a fresh mind. Try this in the Date Header field...

Place the following in a text box in the date header and it will group the report by week number (i.e. the week of 2/3/2002-2/9/2002 will be listed as week 6). =Format([Date],"ww") Hope this helps....

Thanks for your help.

Why don't you create a select query to identify the incorrect records. You could then review the records and make the corrections. The query in SQL View would be something like this: SELECT Table1.id, Table1.CENTER, Table1.Route, Table1.BIL_NAME FROM Table1 WHERE (((Table1.CENTER)<>"ER" And...

In an attempt to move towards a paperless environment, I want to save an Access Report as an HTML document. In doing so, I lose quite a bit of the formatting (i.e. shading, boxes, lines, etc.). Manually reformatting is not an option as the report is 50 pages long. Any suggestions?

Unfortunately that will not work. The problem is that we do not know what the value is because it was never reported. The fact that the issue was reported at all indicates that the value is greater than zero.

Thanks for your help, but unfortunately it did not work.... I will keep trying. :-(

I have a number field that is displayed on a report. There are times when there will be no value stored in the field. When this is the case, I want to display a text message instead of leaving it blank. I use this field for calculations so I cannot change it to a text field. Is there a way...