Is there anyone who could tell me how I can exclude ZERO
when I calculate standard deviation?  I need to calculate
standard deviation after the data grouped, that is the
standard deviation is within the group (not aggregate). So

Access 2003:
I created a report for a table (by using the Wizard) and made a grouping
level on my date field. I then set the group on property to be Week. All is
well, the data is sorted by week. I just have one small requirement. The

   I have a problem that I'm hoping someone can help me with.  I'm not very
experimented with reports in access so I need a step by step or example if
possible.
   I have created a report in access that is a compilation of several small

I'm trying to make a bar chart (using the wizard) but I'm new to charts in
Access and can't seem to have any luck. Can anyone help me get started with
this? I need the chart to show job number on the left and have a bar
extending from the job start date (dates across the bottom) ...

I came across the answer before but can't find it when I need it...
I am trying to create a table in a report in which fields can grow and
shrink.  I am trying to find the coding the automatically adjust the line
length in consequence of the content of the cell/field.

I have a field that adds two other fields. When one or
both of the other two fields are null I get an #Error in
the block as Expected. I would like to trap for this so I
can display an alternate text box instead. I have seen it

I want my report to calculate the total of a group of cells. I have a report
that shows a daily total but I want all the daily totals figured at the end
of the report. How do I do that?

I have a report that has a group heading.  The report
displays claims that companies have made.  Each group
heading display the company's info (address, phone).  My
problem is when my report gives two claims for the same

Hi, I want to highlight a date, so that when six months has elapsed the date
would go red or any other colour.
Any help would be appreciated, any actual wording of what I need to enter in
the conditional formatting would also be helpful.

We want to do a mass mailing to clients who are on our
database. The problem we have is:
Within the text of the letter we need to enter the data
from a textbox, on the current form, and then continue

I would like to control the background color of a field
on a report during printing.  I tried modifying the
background with the following code on the OnFormat Event:
  Me.FieldName.BackColor = VbRed

Is it possible to have a field in the title of a report
that the user can fill in before the report is printed?  
I am creating a switchboard as the user is unfamiliar
with Access but the report I have created needs to have

An mdb has a report with a large embedded file file in it. Is there a way to
find out the size of the report (kbytes) using code or something else?

Hi there. Using A02 on XP. I have a report and 6 queries.
I open the report and print, then go to design view and
change the control source to the next query, run, print,
design view, change control source, run, print, etc. How

I have a rather complex report that has 7 queries as a record source for the
report.  The report displays a count of the records returned for each of the
seven queries. All works fine as long as each query returns at least one
record. My problem is (obviously) that sometimes one ...