Hell
I create reports in Access 2000, and set the margins to 0.5 inches an
landscape, print reports, go back a little later and all is ok.
However, the settings are not saved permanently - they revert back t

I have created a database with a series of reports. These reports are called
up in a preview state from forms. They always come up in the fit mode
instead of 100%. Is there anyway for them to come up in the 100% view by
default?

I have data in one table sth like this...
 test id name qty amt
     3 xyz 1 12
     3 xyz 2 24

I am trying to create a report based on a query.  My report will not display
the entire content of the field whose type is 'Memo' with more than 255
characters. How do I get the report to display all the information in the
field.

I'm trying to create a formula in the report footer that will calculate
values greater than 12. For example, if a value is 12 or less I don't want to
calculate it, if the value is greater than 12 I want to multiply the amount
greater than 12 by 5.5 (if 16 then 5.5 X 4). Your help ...

I have a main report with 6 subreports. Is it possible to have one of the
subreports print a multicolumn report?
Marianne

I have set up a public function called...
Public Function Total_Weight(X) As Integer
   'updated 02/08/05
   If IsNull(X) Then

I am using a formula in the Page Header of my report that is working
properly on the first page and not the second.  The page header consists of a
Title & my date formula.  The title properly appears on all pages.  However,
the dates are only working on the first page.  On the ...

I have a field, type is date/time, value is 11/30/2004. I like to convert it
to November, 2004 or just November. How can I do this?
Thanks in advance,
Sarah

I have subreports on my report, that need a border around them. I set
the borderstyle to show, and it works fine, except when there is no
data for the subreport.
Is there a way to get the border to show anyway (so the user will see a

I've got a main report with two subreports. There's no guarantee that a child
record will exist in the subreports for each parent record in the main
report. Each subreport has a "total" field in the footer that I want to
reference on the main report. In a situation where there is ...

How do I use the command button on a form to print preview a report for only
the one record I was viewing in the form? It use to work in 2.0 but doesn't
in 2000 or later versions.

Please help!
my table has the following fields
- OrderNumber
- OrderDate

I have a very simple report, most of the work is just a matter of a query and
a flat report with some totals . . .  .totals is where I am running into the
problem.
I have some fields in a table, that are of "Currency" format.  I am

I am using Accss 2000 to create a report, but I can't
seem to use expressions on my report to any degree of
luck. My report runs off of a query. It looks like
anything that I want a function on or calculate I have to