I've linked a jpeg to a bound object (OLE) and the report only prints the
name of the file.

How do I set up an IIF Statement in a Report  that has three conditions.  I
have used the follwoing statement but it only uses two conditions.  When I
add to the statement LunchType="S"  It does not read the Grade>="7".  It
gives me all records that is equal to H or S in the ...

When working with text parameters for a query for a report, I use...
   Like [Enter ProductID] & "*"
That way, the user can enter a ProductID to return a specific Product,
partial ProductID to return a "range" of Products, or leave blank to return

Hi, why is it that when i try and produce a report, i get get a error saying
i need to have a printer connected to the computer?
The computer is connected to a printer via a network.
I am using office 2000.

I have a form that the user chooses date parameters to run a report. The
code behind the OK button is
Private Sub cmdok_Click()
Dim strReport As String     'Name of report to open.

I need to assign a serial number to a custom label report that changes each
time the label prints even if it is the same record. The number has to be
consecutive.  The label are for incoming shipments which have multiple pallets

I am using a reference table to populate a field on a form that works well.  
The ID Name appears when selected.  When I use it on a report I get the ID
Number instead of the ID Name.  What do I need to do to get the ID Name to
appear in the report.

I have a client management database for a law firm which contains a "Client
Information" form.  This form contains client data along with combo boxes
that allow users to assign an attorney, a status, a case type, etc. to the
particular record from drop down lists.  These pre-set ...

I've got a report where when I select the report I choose
from a combo box what category I want the report to pull
up.  How can I create another option in the combo box to
print "All" instead of selecting only one item.  

I have a Text field that contains apartment numbers that vary from 1a-25l.
How can I sort so that the numeric floors are in sequence, ie 1A--9L, 10A,
11,A rather than the text sort I receive of 10A,...10L, 1A, 1B,...
Any ideas

I have a report for which I need to force a page break for 2 conditions, one
is when the member ID changes (I am able to set up a grouping for this and it
works fine).  However, when the number of detail lines for a member exceeds
8, I need to print the remainder of the form ...

I am an Access novice who needs some help.  My report derives its data from a
query which returns a number of variables including [C_P] (value either "C"
or"P") and Centres.name.  
If I use Centres.name in a text box, the value of Centres.name is printed as

I posted a question earlier, but after having messed with my report, the
conditions are a bit different.  
My report contains two subreports.  There is always a page break between
them, leaving large spaces between them.  All the "Force New Page" codes that

How can I display data for checkbox in the report if that checkbox is
checked as yes? I mean..if no checkbox is checked none should be displayed in
the report and if user checks..say one or two checkboxes in the form..I want
them to be displayed in the report.

Is there an expression I can use to take just the year from a date field on a
form and insert it into a text box on a report: