I am having a problem with this:  I am trying to add sums. The report was
working fine, until I realised that if 1 of the sum fields do not contain
data, which is a possibility, the full total is not calculated.
I know and have successfully used this formula before:

I have a query which shows 2 fields.  It counts the how many of each status
has occured in the database.  eg. Withdrawn 2, Issued permit 53, Sent back 5
etc.  What I need is to have all of the statuses showing in a report (even
zero values)  There are approximately 10 different ...

I have built a report with lots of small text boxes which I am trying to tidy
up in the Report Design screen. I can find no way of getting the zoom
function to work in anything but the Report preview, where I cannot change
any of the layout.

I have read lots of posts and tried some of them, but I cannot get it right.
I need help!
I have a main report (ReportTrial1) and a Sub-Report (ReportTrial3).
I need to add 2 fields: 1 located in the main form named ConsultID

Hey guys, quick question.
I call my access reports through my VB application.  Is there any way
to pass variables to my access report from my VB App?
I want to pass what options the users selected from the main form.

In my database, one report can be viewed by clicking a button on two forms.  
The report is based on a query, that brings the value of a field [CID] from
the forms.  Now, I make 2 duplicate both the query and the report into 2
versions; in query1, the criteria is CID=[Form1]![CID] ...

I am creating a Database, on my one Form i have Multiple forms that are
suposed to link to multiple reports and when i click for report preview the
report is empty does any one know how to fix this problem?

I have grouped 'Question' text box (not big) on my report and the "Answer"
taxt box, which is linked to the Memo field. This 'Answer' text box on the
Detail part of my report. It's big with a page break after it. So, I can see
it only on the next page of the report in printview.

I am using Access 2000
I have created a report that will be run monthly.  I would like to add a
date formula in the heading that will give a monthly date (Ex:  May, 2005)
for the next month.  In order words, I am running the report today (June 21,

I have a column that holds the duration of calls (duration) in which I'm
trying to sum per ext: ie:104
the current format is hh:mm:ss and the column would look something like this:
00:00:21

I have a report with a text box named txtGridDate in the report header.
It’s Control Source is     =DateSerial(Year(Date()),Month(Date()),1)  
and is formatted as mmmm/yyyy which gives me July/2005.
I would like to have a popup form with an Option Group to

I have a report that contains a DOB field that is properly formatted as a
Date field in the table. The query upon which the report is based is ordered
by the field DOB ASC and when the query is run, the rec's are ordered
properly by date. The report, however shows some dates ...

Would like to resize a reports detail section if a field is null to get more
contacts per page. My code below works to show and hide the field but does
not resize. Help.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

How can I get a Sub-report to print on the first page only.  I have been able
to put it in the report footer so it prints on the last page.  But, I'd like
it on the first.  Any help is much appreciated

I created a query where I used the expressions Month:Format([Date],"mmm") to
convert individual dates from my table and group them by month. In the same
query I used the DatePart("m",[Date]) to order them chronologically not
alphabetically. This query is used to create another ...