Hello all.  I am doing a report that has to serve two groups of people..  On
report has to have all fields and the on is the same report but with less
fields..
My question is if I can keep the same report but in one not print some of

I'm still relatively new working with Access and on top of that I've
inherited the managment of someone else's database. I am trying to generate a
report for invoices for a contract.  We have several contracts, each with a
unique contract number (contract) and each contract ...

I have a report with 600 pages...each page for a different client.  Is
there a way to have Access automatically save each page  as a separate
report?  I would want each page saved using the client name field.

i have a database that holds all the information about our clients. We have
an outpatient program which is billed according to how many group sessions
they attend. What I'd like to do is generate a report that shows which
clients attended group on a particular day. I have a ...

I export reports to Excel....I just upgraded from Office 2003 to 2007. I got everything upgraded correctly, except excel is not an option anymore when you run a report. Anyone know the work around on this or what I can do to have Excel be an option under the report function?

Is there anyway to display some unbound fields in a form to report?
To be more specific, this is the situation.
There is a quotation form which has discount field (unbounded) that
subtracting its value from total amount field (bounded).

I have seventeen regions that represent sales areas around the country. I
have all seventeen regions listed as column headings in the crosstab query so
they show in the order I would like. If one of the regions is "null" the
region does not display in the query, which is great.  ...

I got a access table which is like the following
Group   Description         Amount
3000     Net Sales           100000
5000     Total Var Cost      75000

eg.
  A    100
  B      50
  Sql to get result as C 50 (This 50 is actually a calculation of 100-50).

I tried to post this earlier and received an error.  Sorry if it's double
posted.
I have a report in the form main report with 2 subreports.  The subreports
are for customer and prospect calls.  Often times there are no prospect calls

Hello --
Can Access develop a report in Excel with shaded areas to denote a used
resource for a given timeframe?
I am building a database that will hold schedules for Trainers and Training

I am trying to create a report which performs an analysis of the cost of
running an event.
I want the report/pivottable to be split into 2 sections, income and
expenditure. Within each section there will be 3 further fields. I want a

Hello all, I have a tricky summing problem for my report.  It has the
fields Department, Priority, Category, Course, CountofEmployees, and
SumofCosts.  It lists courses taken in each department, each with the
number of employees per class and total cost of sending that number of

I have created a report in access which is like a printable form.It is
populated with fields .The form needs to have lines(EX. Name:
__________________).I tried to place lines using the toolbox below each of
the fields.Also it has a design including color field rectangles.My problem

I have created a crosstab query in which some cells are null. There is
a report based on this query in which I want to create a field that
creates a sub-total for the row. As soon as the formula encounters an
empty field it returns a null result. What do I have to do to get the