I have a form with a drop down selection box in the header.  The ID selected,
displays data on body of the form, then there is a subform to allow the user
to add data.
There are 2 problems I'm having.  1)  If an Id is selected, but the user

Is there a way that a negative value can have it's color changed to red so it
stands out to other data?

I have a report that I need to generate 3 different results.  I have tried
=(iif([e]=[b],"No Change") or (iif([e]>[b],"Increased), or (iif([e]<[b],
"Decreased"))))
I am kinda of new to Access in developing complicated Iif statements, can

I have a main report which has several subreports imbedded.  When I run my
report, if the last subreport on the page runs long, it automatically goes to
page 2.  Is there a way, that when this does happen that it will print the
report headers for that subreport on page 2 not just ...

I've been struggling with this although I'm sure it's fairly simple.  I need
to have a report that is broken down in 4 levels (District, Subdistrict,
Area, Field) and inside each level there are some fields (regarding
Inspections) which I need to count or sum but I need to do it ...

I have a database that has 2 tables. One table is a number (IP Adress) and a
username. The other table has a number (IPAdress - linked to 1st table to get
the username) date, time, web page.
It's basically a internet usage report. The server creates a spreadsheet

I can create a form that summarizes by data as shown:
Title 1: XXXXX
Contact: John
Stage     Name    Date     Comment

I need to know how to remove a form feed from an Access Report.  When I run
two reports they alway form feed.  I need to be able to print one report and
stop on a dot matrix printer, then when I am ready to print the last report,
print and then form feed to tear off.

I have a report and I need to be able to add parameters for the report, ie
one of the parameters is customer name, I need to be able to for the report
either enter one customer name or multiple customer names for the report, How
can I do this?

I am plotting 2 y-values for each x value and am wondering how to add a
secondary y-axis on the right of the graph to show the different range of y
values. Thanks for any help.

I am using Access 2000.
We have a dB to keep track of our quotes.  One quote may have different line
items.  Each quote has a follow up date.  I want to run a report that is
based on follow up date (for each quote) that shows the Company information

I have calculated field on my report. All is working fine when all data
exist, but when there is no data it is displaying #Error. I have tried
different variations of the IIf statement but nothing works so far. My
original calculations are as follows:

Greetings to all,
I am trying to create an embedded standard report, and need to pass a user
input variable from the main report. Both reports are almost identical, from
two queries each with a different field to match between the tables. I need

Hi, This is a continuation of my previous post on 6/9/2005 "Questions on
Control boxes, Parameter queries and calendars in reports."
As background, I am using Access 2003 on a PC with WIN XP Professional.  I
have a report based on a three parameter query with the 3 parameters ...

I have an application that is being used by 50+ people in two locations all
sharing a single SQL db.
For some users one report prints at the printer the developers used.  A
different person can sign on at the same machine and the report will go to