How can I change this expression to add 0 to any null values?
soflinesum: Sum([qty]*[price])
TIA
Les

I have a report that is grouped by custname.  In the detail section, I will
have how many orders the customer had.  I want to count how many customers
there are, but I am having trouble.
I have the custname as a header, put in a unbound textbox and put =1 and set

I am attempting to perform a lookup on a report and having some problems.  
First some background.  I have a table called Assessment_Grade with 2 columns
in it – one for assessment_rating and one for assessment_grade.  For example
the rating is high and the grade is 3, or moderate ...

I created a report based on a query with 2 parameters. The report works fine.
Now I am adding a subreport linked to the main report primary key. When
previewing the report it asks for the 2 parameters I expect. But then it asks
for a mysterious third parameter . Its as if all ...

I have a report with a macro that hides certain images depending on the page
number.  In print preview the images are where they're supposed to be, but
they do not print.  This isn't a printer problem.  As far as I can tell it's
a macro problem.

I have a report that is not bound, "rptTestDetail", and it contains a
pivot chart.
However, "rptTestDetail" also has text data in it from sub reports. i
am trying to make the text data the same color as the pivot chart

The settings in my page setup change back to the default.  
This happens sporadically when I go into design mode.  I
usually have custom margins, columns, etc.  From time to
time when I open the report the margins will have reverted

Ok, here goes.
I have a report based on a Crosstab Query with dates that vary.
I want to check each date to see if it is on the Holidays table
(T:Holidays), and return it's ID from that table if it is.

I have a Totals line in the Report Total section that I want to print
exactly 4 inches from the bottom of the page regardless of how many detail
lines are present.
Currently the position of the Totals line is dependent on how many detail

Can anyone tell me the order in which report events fire?

I have a 2 applications at work that I'm trying to make work together.  The
first is an  ACCESS 2000 database that tracks and assigns project numbers to
capital projects at the plant.  I'm using the database to help me monitor and
track change as part of ISO requirements.

I need to put in overall report totals for client contribution, client hours
billed, and client hours not billed.  I have in the client summary band the
following controls
'sums data from the detail band

I have a rox of textboxes in the detail section of a report, all with the
'Can Grow' property set to Yes as well as the 'Can Grow' property of the
deatil section. I want to make all boxes become the same height if any of
them grows to accommodate longer values. Thank you in ...

I have a report that would use one of two queries, depending on the status of
a field in the main database table.
The field in the table is called "In-House", and is set as a Yes/No field.  
What I want to be able to do, is, upon opening the report, to have it check

I have a report that may have many pages to it.  The header on the first
page must be at the top of every page of the report. Is their a way set the
header on each page of the report requested?