I am trying to show the value of a currency field (format as euro) in a
report.
all fine as long as it isn't e.g. 41,60  ... then it turns to 41,6 in the
report .... I use the expression builder for creating the whole text

I am using this expression in a text box to calculate a percentage of errors.
=CDbl([Prep_Err_txt].[Value])/IIf(CDbl([Prep_Batch_Total_txt].[Value])=0,1,CDbl([Prep_Batch_Total_txt].[Value]))
These are the expressions used for the Prep_Err-txt and Prep_Batch_Total_txt
fields, ...

Here are the two tables and pertinent fields I need to report:
tblFinishedGoods
txtProfileID (PK)
tblFGUnitLoadLayerParameters

I have a grouping of information and that grouping is the information that I
want to sum by.  The catch is that within that grouping I have another field
called "Status".  I only want to sum the records that have a certain value
for the "Status" field.  Is there a way to do that?

I have a report that needs to show the MONTH and it’s specific DOLLAR value
horizontally.  I have showing vertically, not a problem, but the VP wants it
horizontally, and wants to show every month even if there is a null value.  
The report needs to read as :

When running a report that has no records in the results I am unable to show
the Start Date and End Date (criteria) from the query.  If there is data
present the dates will show.  The control source for each is as follows:
[Enter Start Date:] and [Enter End Date]

I have a report that is based on a query and the report prints out 1 page for
each record. How can I suppress null fields for a record, so that they do not
print on the report, and have any subsequent fields move up on the page?

We have an access 97 application that will create an email and sent off
a report in a .rft format, the problem is for a couple of our users the
report headings and columns get cut off for some reason.  For most of
the users when they genereate and send the report it shows up fine ...

I have a summary report that will have upwards of 200 individual items of
data on it.  Sometimes, this data will be blank.  If the data is blank, is
there a way to suppress the printing of the associated label/text box using
an "if" statement, so that I dont have large gaps of ...

One of my reports has a blank page at the end; I have the report footer
height set to 0; I have tried all kinds of page set ups;is there any other
way to solve that?
Thanks a lot,

Is it possible to total fields in an existing report?  I basically got a
report of our organisations current service profile and was wondering wether
it would be possible to total the hours and WTE of each team.  
If so please let me know thanks alot

I am unable to format a date range from a query to a report
The query asks for [Start Date] and [End Date].
The [Start Date] and [End Date] are place on the report header.
Unable to format using the format property ot the text box.

This Q have probably been up before but I havn´t found any info. about it so
I post this Q probably once again.
Is there a way to create a pdf-file of a report from Access 2003?
Thank´s in advance?

I have now tested it and it works just great!
Thank´s!
// Niklas

I have a report which I run which creates a billing report for numerous
locations.  By request of the accounting department, they want the reports in
Excel.
I know that there is the ability to export the report to Excel.  Is there an