i currently have this in a report
=Sum(IIf([SETH] In (1,2,3,6,7,8,9,10,11,12)1,0)
i want to count another field in my report  how would i do
that    would this be correct

I have a parameter query that prompts the user for month begin and end dates
- I want my report to use the month supplied by the query and add it to the
report header.
I also don't want the user to be prompted again for the values when the

I have a main report grouped by Department Manager.  I have two subreports
under each manager that: 1. counts the new ideas submitted and 2. counts the
number of ideas implemented.  If no ideas were either submitted or
implemented in a quarter, that managers section is blank.  I ...

I have a report that has fields in the header and footer sections with 2
subforms in the details.  The pagination is controlled by the subforms - if
one needs another page it does it.  That is working fine.
My problem - I want to do a "page n  of x pages", but not have the "of x

Ok, I need some help on this one. I am sure it can be done, but I am not sure
where to start. I would like to create a single report template and then
depending on which query is run, output to the results to the report template.
So for example, I have a report with 4 unbound ...

I have an access report with several graphs. If certain criteria are met, I
want a 'signal' if these indicators need attention. For example, QTY1 is
greater than QTY2, format a cell RED; if they are equal, format cell YELLOW;
if QTY1 is less than QTY2, format cell to GREEN.

I save a form as a report - there are a hundered check boxes...When I export
to WORD  - everthing prints but the values in the chexk box. I even put some
code in the On format section to print an X if the value is true - This works
when I preview the report - but when I send to ...

I have a report with a CategoryID header and footer.  In the detail
section I have the ProductID field, Quantity field and a Price field
with the calculation Quantity * Unit PRice.  In the CategoryID footer
I have a text box for a subtotal of that category

When my A4 portrait reports open in Print Preview, they open with the size
chosen as "Fit". I have to select a different magnification each time in
order to read the report. Is there a way I can get the report to open in
Print Preview at a specified magnification?

Morning all
Does someone know how to do a report that shows me a cash breakdown for a
wages database. i.e. if someone earns $53,000 I need to know how to
automatically make it work out that I need 2 $20,000 notes, 1 x $10,000

I have a report which utilises various calculations mostly done in the
underlying SQL statement. However in the report I need to divide all results
by another field. Most work OK but 2 of the controls return #error. All use
the same calculation i.e. =[field name] / [Euro ...

He
When I preview my Report which is designed to cover the whole Page its ok
but
when i print my report the ReportHead is printed over 2 pages.

Here is my problem.  I have a continuous feed impact printer.  But my access
reports are forcing me to have a bottom and a top margin of .5 inches.  I
cannot have these margins are important information goes on the very bottom
of form being printed on.  When I set bottom border ...

I have a report that has a cross tab query as its record source & that cross
tab will have heading.  So I have the design of the report carried out
programmatically.  My code is below to give you an idea iof what I have
done.  However, at run time I need to have a field change color ...

Here's the sitch...
I've got multi-forms (3 to a page, perforated), tractor feed, 11 x 14,
Lexmark Forms printer, Generic/Text Only driver, 0" margins.
I've created a report that will print on the forms, set up into 3 columns.