I am developing a good size app in Access 2003 with a FE / BE configuration
with most of my users using a Run Time version of Access that I will include
in my install package.
Currently all the reports and associated report forms are defined in the FE

When running a report from a workorder database,I would like to set a format
to change the font of a number if the the number before it is less than that
field -1. Just to help point out a missing workorder number.  I'm sure there
is an eay way to do it, but I do not know it.

I need to produce 800+ reports which can have one of 5 cover letters,
depending on the contents of a data field which identifies the author.  
During collation, we need to add various inserts to individual reports, and
coordinating all the pieces requires that the letters be in ...

I am trying to use a differnt picture to appear when I run my reports.  How
do I set this up in forms, and so forth.  I want to have a list in forms and
select which picture I would like to insert into my report when I run it.

I have to create a report that needs to give some calculations at the end of
the report.  The summary would be:
Items Delivered:  ItemDel
Items Installed:   ItemInst

I would like to know if there is a way to sum a count if statement in a
report footer.  
=IIf(Count([Acct Num])>=5,1,0)
I need to add the results of this equation.  I've tried to

I have a report based on a query; the user should enter a criteria from the
query when runs the report; for example [enter store number].
I would like to show the store number in the report when there are no
records; or some message, like "No records for that store"

This must have been asked before but I can't find anything.
I have a database from which users can print and save (as an rtf file) a
quarterly report.  What I would like to do is ensure that when a report is
saved it is given a unique name so that it does not save over reports for

I have a report with 2 subreports. SOmetimes the first subreport is excluded
from the report. When this occurs, i would like to move the second subreport
up the page so there is no gap between my header detail on the main report
and my sub2. Does anyone know how to dynamically ...

I'm trying to print labels ordered down rather than the default (across) order produced by the label wizard.
I would like:
Ben    Jacob   Jordan
Cris   Jenna   Nate

I have a report that contains 3 sub-reports, each with a number of records
displayed from separate queries.  I need to get a row total (i.e the sum of
all the first records of each of the sub-reports in a text box of the main
report, then in another text box a sum of all the ...

How come my report first page there is always a big blank before rest of the
record but after the first page of report, other records all display nicely
together?  I change most of the properties but it does not help.

I print a report using Access 2000. The report is one page long and based on
one record.
Depending upon the data, I might change the for color or back color of a
text box, or make it invisible entirely. I do this with some code in the

In Microsoft Access I am in need of adding footnote references (letters) to
the end of a text field. I cannot figure out how I can apply the footnote to
have superscript and italics, while the text is in another Font Type. The
challenging issue is how th tie the footnote to the ...

Ive got a report system working nicely now (Thanks to many people here), but
now the end user has changed their mind again.  At present it lists clients
name/address and product for each product.  Due to the data a single client
may have many products but at present it just ...