the I have a calculated field in a report. I need calc field to round to 2 decimal places and if the decimal is greater than .00 (from .01 to .99) then the...

Hi, I would like to calculate the number of paragraphs in a field comprised of text? The data is in SQLServer and I have both RTF and plain text columns of...

I current have a query that I export to excel, create a pivot table then format it to print. I do this on a weekly basis. Can access create a Pivot table or...

Hello. It has been a while. I have a report that is based on a query. On the query form, I have created a "print report" radio button. This report prints...

Hi Friends, I have a question i dont know if its a legit question or not. I have a report that has only one column and a chart in the botton of the report. The...

I have a subreport in my main report but when I print the report the report total prints on the next page even if there is room to print it on the first page....

I have a problem with page margins, if I change a margin on a report and save all. when the report is reopened the margins have reverted to default values. Any...

I have a query from which an invoice is printed. How do I eliminate blank address lines? For example if I have address_line1,...

Hello! I am creating a report in Access. The report contains membership information such as name, address, email, etc. There are some members who do not...

I am building a report containing 2 unrelated parallel subreports. Each subreport has severel groups that may contain a different number of records. How do I...

I set a macro to run by selecting it in the properties of a Report - Details (Report // Properties // Details // Event tab // On Print set to Macro 1) The...

MY subreport has so much data it span to two pages when I print my report I get first page with main report data which is by the way only four line covering...

Simple but I can't find. I want to adjust the spacing between row on a report.

I have 3 cbos: Employee Name, Report Type and Report Instance. The user selects the Employee Name then the Report Type (this cbo is populated through a SQL...

I am duplicating a form with an access report. The form is a half-page timesheet--I would like to print the first half of the ordered query recordset on the...

I am using DAP's to generate a large variety of similar bar charts. All of the series data (stacked bar) is broken down into 11 categories but not all of the...

I have a report based on a query which I email out daily to over 40 different managers using the SendObject command. The report has a different header...

How?

Hello: I am creating a new database which has a field for Sponsor's name, just the name so it is not worth creating a separate sponsor's table, when an...

Hello! You were such great help to me yesterday, so I'm back! My new situation is this...I'm trying to construct a report so that the holders of various...