I'm self-teaching on Access as I develop a client tracking database
for my facility.  I'm probably going to say this wrong, but here goes.
I have a report where I only want to have a particular field
(control?) visible if the data in the field it is boud to says a

Okay, I am working on a student database.  Here is how it is set up,
specifically related to this problem...
1.  StudentContactInfo table/form  This includes an "Inactive" yes/no field
for when students are no longer in the program.

I have a report called contactheader.
At the header level, I have [PL] from tblcontacts, as well as other
information.
In the details I have all the subrecords from tblemployees where

I am using Access 2007. I am trying to set criteria prompts when running a
report, which is linked to a query. I am specifically looking for the report
to prompt for a start and end date, and also to prompt for a name. Can't I
set this criteria to come up as prompts when the ...

A query delivers somuch data that I can not put all the information on one
page. Is it possible to create nice and neat multiple page reports?
Thanks for suggestionsand answersto the above question?
Ron

How can I go about capturing just the first letter of each name so that John
Smith would look like JS.
The code that I am using is Left([Name], 1) which works great if there is
only one name.

I need to force a new column on a report. how can I do it?
thanks

=DCount("[ToolID]","tblTools","[LoadDue]   >= [DateNow] AND [LoadAct] IsNull")
ToolID is a field in my table that is an autonumber (hence, always
populated), tblTools is the table in which ToolID, LoadDue, and LoadAct
reside.  DateNow is field on my actual report.  For some reason ...

I have designed a summary report that shows average ratings respondents give
for seminar sessions. I have several subreports based on different queries
that give me a Respondents ID number, full name, and any verbatim comments
the respondent made.    Clients and instructors now ...

I thought this was easy! I have a report with a control called NbrAdults. I
have created a calculated control in the page footer called adults whose
record source is =Sum([NbrAdults]) as I want to count how many adults are
coming to an event so I thought it was just a simple Sum ...

I have created a report which is an order form for ordering parts from
different companies. There is a fresh page for each company and the page
displays a list of the orders from the company.
It works well apart from the first page displays the first item then leaves

I have Access 2003.  I have a field on my report named RELATED.  I only want
the field to show if RELATED = CON or CIP or DIV.  Otherwise, I don't want it
visible.  
I'm thinking I should add a text box with Control Source, but I'm not sure

I have a report that needs to be printed on a dot-matrix printer (and this
is not the default printer). The area of one form, not including the tractor
feed area, is 8.5" wide x 7" high. In the Access report designer, the
report's size is: 8" wide x 6.5" high. For the Page Setup ...

Every time I try to open a particular report, I get an error that says
'Overflow', and the report won't open.  The query that it's based on works
fine.  I can open the report in design view only.  
Has anyone see this error before and know what it means?  Its so vague . . .

    I have a report where the data i want to have the name of the person to be
selected on the report rather than go record by record to search his name. Is
there a way a combo box can do the selection of the name on the report.