How do I default a zero in a field on a report?
The onlt thing is if the value in the query is higher than zero than I want
that not the zero.

Hey Peeps,
I am currently creating a report in access, it has several sub-reports
inserted into it and i need to format a contents page at the start of main
report between the title page and the body of the document.

Hi everyone :-)
I am having the strangest problem in Access. I have created a cross-tab
report that groups on several fields. It uses two queries and a bunch of
DLookups to populate the fields.

I have a simple receipt that prints when a payment is posted. It prints a
second blank page everytime. What will it take to have it stop doing this.
I'm using Office XP pro and the whole receipt is in detail with no headers
of footers.

i have a table structure similar to the following with some sample data.
                  Part        Def     Def     Def     Def     Def    Def    
         Total    
ID   Date    Number   Code1  Qty1  Code2  Qty2  Code3  Qty3  Other   Sort

"Microsoft Office Can't Find The Field <field_name> referred to in your
expression"
My basic aim is to compare two numeric values, and colour code the reports
results accordingly.

My individual iif statements work beautifully but I need to add them to get a
grand total.  Is there a way to add the two iif statements in the control
source for a report?  I am missing something and I don't know what it is.  
Help!

I have a field in a report that i only want to display if another
field has a 3.  then i will only total jobs that were completed.
I have tried the following IIF([JobStatus]="3",[SalesSpiff],"") i have
tired with many different combinations but still cannot get this to

I asked this question a couple weeks ago and got a
response but I didn't have a chance to try the
recommendation until now.  The suggestion was referencing
the Access web site under Forms: Adding "All" to a listbox

i have a table with the following design
ID   Date    PartNum   DCode1  DQty1  DCode2  DQty2  DCode3  DQty3  Other TtlSort
=====================================================
5   6/30/04 012009-732      1    6           4         5         2    4        7    

I'm having an issue with charts in a couple of different databases.  They
display fine in print preview, but when I print them on our HP inkjet, all I
get is the axes and titles - the data bars are missing.  When I try to export
the reports to HTML, I don't see the chart at all.

I am doing a db to record Account Transactions. In the db, there are a few
types of report, eg. View Transactions per month, View per year, View by
supplier. I have almost completed the db except one problem - when I run the
report, it overrides my data in the table!

Hi, how do I create a report to display two queries in two sections????
The first section would display the first query.
Then the second section would display the second query...
Thanks.

I have a report which does not allow multiple Account Names to show on the
report even though by other fields these records are unique.
I have tried allow duplicates and can grow.  What am I missing to allow
these records to appear?

When opening up a report I would like to have a parameter box open asking
what the starting page number should be? Is this possible. If not, is there a
way to just open the report in design view and change the starting page
number in the footer? Thanks.