I have a strange problem with reports in a particular database.  I set up
the design of the report including Landscape and margin sizes and save the
report.  but then when I open the report the setup has changed back to
portrait and the margins are all out.

Hi group,
My application display (forms) and print (reports) with Access 2000 and
Access 2002.
On a new PC with Office 2003 installed the reports  no longer print images

Hello, I am trying to format a report in a way so that if  I have two equal
dates I can somehow change the output of my report.  I will first explain
what I am working on  for a better understanding.  This report is generated
by a query that has some imput parameters as arrival - ...

I have a on activate event on my report filling a report field when the
report is shown in preview mode.
This did work fine until i changed the report property popup to yes (this
was necessary because the report preview is opened from a modal/pop-up form

I have a database that was written in Access 2000.  It's on a network,
and some users run it with Access 2000, but one computer runs it with
Access 2003.  This worked fine while we were sharing it on a Netware
4.12 server.  Last week we replaced that server with a Microsoft Server

I created an Access report based on several queries, and the report has taken
some of the data more than once from the query.  This affects the sum, since
duplicate data is added in to the total.  What can I do?

I have a report that is generated by a query.
My Query1 has these fields: fDate, Name, Amt  In the Critiera field for
(fDate) I have: Between [Start Date] and [Ending Date].
This all works fine on the report with Sum for Amt at the end of the report.

I have a report that is generated by a query.
My Query1 has these fields: fDate, Name, Amt In the Critiera field for
(fDate) I have: Between [Start Date] and [Ending Date].
This all works fine on the report with Sum for Amt at the end of the report.

I have a report where the zip codes are based on a input mask that
includes the hyphen. When I print 5 digit zip codes the hyphen is
visible. I have tried:
=Trim([ShippingCity] & "," & " " & [ShippingState] & " " &

I am modifying a report in ac 97.
I added a report footer, and moved the page footer up to last session/group
footer area. However, when it prints, the report footer is on its own page,
even it is small enough to fit in the blank space left on the bottom part of

Is there a way to set the visibility of a line that is located in the detail
section of a report according to a value in the current record? The line's
visible property does not seem to accept a formula.
Regards,

I have a formula in an old Approach Database that I need to set as the
control source to an unbound field in Access on a report.  How would I
convert it?  Here's the formula:
If("Total # of Days" = 'N/A' and "Closed Date" > '', 'OK', If("Total # of

Is it possible to have a report reference more than one table?

I have a one-record summary query which has 8 fields. I am trying to graph
these, in a report, so that each value shows up as a vertical bar, along the
X axis, and their values go up the Y axis.
I've used the charting wizards in Access unsuccessfully. Either they will

I have subreports in a master report and the field all the queries
depend on is a date. I would like to only enter the date once but each
query asks me for the same information. Is there a way I can enter the
date once and have it carry through all of my queries for that report?