I have an Excel report with a legend box on the right.  I am trying to
recreate this report in Access but am not sure how to do it. Either it is
repeating with every record or it shows at the TOP of the report or page.  I
want it on the RIGHT of the report.  I thought about using ...

I use the "Format....Horizonal Spacing...Increase" menu item very VERY often
while creating reports but Access does not have an option to add that command
to the toolbar.  Does anyone know...
a) How to add this command to the toolbar, or

I created a database to enter in personnel and their status such as who is on
vacation, who is working in another office, and who has appointments for the
day.  I went through and created queries for each table such as appointments,
vacation, etc...  When I go to add them to my ...

I have a series of buttons on a form which open the same report but
with different criteria.
eg
DoCmd.OpenReport stDocName, acPreview, , "Estimator= forms!DataDrill!

I have created a report called PreJob's which pulls information from two
different tables; Work Order Main T and Order Details T.  I am pulling
information from a field called Job Description from the Work Order Main T
and Operator Name from the Order Details T, now the Operator ...

I'm trying to make a report that will show when a member of an organization
is due for renewal.  The membership is good for one year, and I have fields
that show how much they've paid, and when.
What calculation do I need to compile a list of names of people who expire

I have a program written in VB6 with an mdb file backend on the server in
Access 2000 format. I
have reports that I create on my computer that has Access installed that I
need people on other computers to be able to print. The problem is the old

I have a table "UnitJobs"
it contains the following fields:
WorkerName
HireDate

I have a budget database in which I have a report where I have the following  
4 fields:  [1stQtr]; [2ndQtr]; [3rdQtr]; [4thQtr].
The values for these fields are determined in the query as follows:
1stQtr:

I am using the replace and find option, but continue to get the following
message. "You can't replace the current value of the field with the
replacement text.  Resolve any errors before making further replacements".  
What is this, and how do I correct it?

My report has several grouping levels and works OK.  I am OK with creating a
text box to count the entire number of records in a report and in a group.
But I've been asked to count the number of records printed on any given
report page.  How can I do this?

On a report does the Sorting Property override the recordsource's sort
order.  In other words do I even need to set the sort order in the
recordsource be it a table, query or SQL statement.
Thanks

I need to pull the same data from 2 databases, the both have the same
tablenames. just the history one has data in it older than a year.
This is what I have, it works fine for the current db...
It works fine for the history db, but the problem is when I need data

I have a form which displays customer details and a subform which display  
comments. I've managed to do a report which print what I have in my form but
what I've been struggling is to make the subform to be printed ONLY if
there's information on it. As it was set up to not be ...

I have a field called Evaluation Result, that is either "pass" or "fail" in a
query. I want the Evaluation Result to display the % Pass in a report.
Here is what I have so far:
(sum(iif([Evaluation Result]="Pass", 1,0))/sum(1),percent")