I am working for an engineering firm.  I am doing my monthly billing by
tracking time that each engineer spent on each project during the month.  At
the end of the month, I input all data from the timesheet such as project #,
project name, engineer's name, total hours.  I have ...

I have a fairly complicated report, based on a query.
In the query, there is an expression which uses Switch to add words to some
underlying data, depending on what that data is, to produce a field I call
"AltWds".

I have a totals query that pulls out TotDaysVac and SumOfVac. I would only
like to list the days on my report where TotDaysVac-SumOfVac =0 how do I do
this??

I am trying to create a PivotChart in Access 2002 with 2 axis that each have
a different scale. One that scales from 0 to 100 and the other that scales
from 0 to 30,000. Any one know how to do this? I know how to do it in Excel
but can't figure it out in Access.

How to show the name of the QUERY file at the footer of the report like the
page number?
TIA
Ana

I have report 1.  I have report 2 as a subreport in the report footer of
report 1.
I also have a text box in the report footer of report 1.   Can I set the
textbox (in report 1) value

I have a report containing data on several different tax types.  There are a
dozen or more possilble type of tax.   However, there are two types that make
up the majority of the entries.   How can I gather all of the lesser tax
types under the "Other" group heading.

I have created a report that has several calculated controls in it.  I
have been unable to get a total at any group level by any of the
recommended =Sum() syntax.  For example...
Detail control...

I wanted to know if anyone knows how to create a pivot table in Microsoft
Excel by combining two seperate excel spreadsheets?

I am trying to apply a different color font to a control box.  I can do that
to the first control box using the "conditional formating".  My problem is
that in the report there are two control boxes.  1) Names and 2) totals.  I
would like the word "blank" in the Names column to ...

I am running Access 2000.
I have a report that I created with data source that is a query.
What I need to do is print the output from a second query in the
report footer.

I have a parent table named "Learn" with 2 fields; an autonumber field(pk)
and a text field.  I have a field called "Lrn" in a child table named "App"
that looks up the fields in table "Learn" and Binds the autonumber field.  
When I print reports the autonumber prints.  I would ...

When I want to print document, on my brother all-in-one fax Network Built-In
MFC-3320CN Model "will print a final page with peticulars including author
and word count for example. I would like to stop this final report as it is
using more than I want it to of my ink for ...

I have a query that takes my exhibitor table and my entry table breaks at
each "class" level.  However, I have a class that has no entries.  I would
like to force a page for that class.  It would give me a page with the
"division" "class" and "class description" which resides in ...

I'm using Access 2002, and I'm assigned a task to develop a report which is
going to rank customer sales by city.
I don't know if this is possible to do:
rank / acct# / name / city / sales