Is it possible to add on to this formula to state that if no value to enter 0?
=DSum("[CrGiBgChecked]","[1 deskiewicz]")

I found this code on http://support.microsoft.com/?kbid=296249
Me! pagesum = Me! RunSum - x
x = Me! RunSum
It works great!  Can anyone explain what does the ( Me! ) do?

Before I open a report to print.  I want to do an Application.Printer
First how do I find out using code what printer the report is printing to?
Its usually going to the default printer.  I want to send up an error
message if the printer is disconnected or turned off.  Will the

I have one field as below to show the contents of the fields; Model and
SupModel, depending on the availability of these fields and works correctly.
=IIf(IsNull([Model]),"(" & [SupModel] &
")",IIf(IsNull([SupModel]),[Model],[Model] & " (" & [SupModel] & ")"))

Hi, hope someone can help with this question.
I am trying to convert page numbers to display as roman numerals in a
report.  
Thanks

I have deleted fields that were used in a report. Now every time I try and
open the report I get asked to "Enter Parameter Value" for the deleted field.
Help says to refresh the field list in the toolbar. However that does not
exsist.

I have created a small database to track overtime.  I have a table set
up for employee information, one for entry of overtime (which happens
via a form).  I need to create a report that lists all employees by
shift, regardless if they have worked overtime or not, but include the

I have 3 textboxes on a report that total number of unit sales between
specific dates. I want to add a textbox and have it calculate the highest
number of the other 3 to use in another calculation

Hi Folks - as usual - pulling my hair out!!
I have a report based on a query, and I am trying to change the control
source of a specific field on the report to one or other of the query result
fields, dependant on other criteria. Been 'round the houses' numerous times

I have a table with fields [quantity] [Part#] Description]
In this table records repeat themselves with same part number and
description but the qty changes. I would like a report that combines the
parts numbers that are same and totals the qty. Is this possible?

I wanted to know if DSum could be used for the following:
=Sum ([text174], [BenefitType],[ETR Only])
Which I understand to mean...
Sum everything in Text174, where Benefit Type is ETR Only. Yes??

I have a column that lists approximately 12 different initials.  I would
like all of these initials to appear as a full name on a report.
I am drawing a blank as to how to do this.
Any help at all will be greatly appreciated!

I have an accounting report in Access 2003 that looks like this:  It is
grouped by Student and then by Payment Type (charges, payments, payroll).  
The totals for the payment type groups come out fine but I can't figure out
how to calculate the balance due since the total field ...

Is there a means to have a chart such that a value below a given value is one color and above another value. I am trying to format the chart to show values above $500.00 to display in red and those below in green.
I have the chart and have tried several different types of charts ...

Good Morning,
I have a report with several phone numbers in it; what I would like to
be able to do I format the phone number to ***-***-1234 when printed so
when these reports get distrubuted the wrong people don't get ahold of