I'm using Access 2003 in an Access 2000 format.
I have a report that contains text and a few bitmaps
and .jpg files.  When I try to save the report as a Word
doc, all of the images are missing.  I'm really trying to

Sir,
I designed a customer account satement report. In this
report for some customers there is no data for calcualtion
in certain period. So I am getting #Error as the value in

I'm trying to find a way to way to have Reports Display a 0 if no records are
returned from my query.  I've tried both Select and Crosstab queries.  My
current queries return a blank and I need to replace it with a 0.  I've tried
Count, DCount, Nz and I don't remember what else.  ...

I want to group data into weeks on a report, using Sunday as the end of the
week.  Access is using Saturday, when I group by "week" as the grouping
level.  Does anybody know how to change this?

I'm creating a report where my control source is a query and, the field that
I want to do a dcount is a textbox which is calling a function.  I have
receive result when I use table as a domain, but can I use queries as domain.
I'm using Access 2000

In my database i have two fields, one called CorrectionsRB and another
Corrections WO.These two fields contain a three letter id to identify on my
forms entry screen as either a rebill or write off.A correction amount is
entered on the forms and one of these fields is selected ...

I have a report that need the summary displayed at a different margin on the
second page of the report. I have tried to increase the page header size but
this increases the space between the report header and the detail section on
the first page.

I'm maintaining a system with a VB6 (SP6) front end and an
Access 2000 v9 database running under XP, using ado for
standard database calls. This has worked fine for a few
years now.

I want to draw a line at about 3 inch after the details
section starts, its about middle of the page, therefore, I
wrote the code below at Details section format property :
Me.Line (0,0)-(9240,0)

I want a line just after the 15th Record. I know the code
to draw the line,
Me.Line (0,0)-(9240,0)
But I dont know how to make conditional, so that it will

I use access 2000 with xp and would like to know how to e-
mail a report section, ie., one page of a 10 page
report.Currently, if I e-mail the report all 10 pages are
included.  Any suggestions would be appreciated.

I am trying to cancel the report printing if there is no
data to print.
I tried cancel= true in the onnodata event but I have an
error " macro cancel does not exists"

I'm trying to create a report with various fields (around
6 each month). The problem is that these 6 fields could be
anything. I have a query which pulls the data fine, but
when I try to dynamically set the control source of a

I have a report with a subreport.  I would like to sort
my parent report by some of the data in the subreport.  I
have minimal vb knowledge, so any help would be
appreciated.  What I'd like it to do is sort ascending by

I have created a couple reports run via command buttons on
a form.  Can I use the form on the web to run the
reports?  If not, how do I go about it?
Thanks