I've created two reports, I would now like to combine them together so as to
create a master report.  As such, I created a third report in which I
inserted each of the other reports as sub-reports.  When it asked me define
links (child/parent) I put none.  The 1st report is 11 ...

I have created a report that subcategorizes customers
into certain (multiple)demographics.  I have 3 queries
that are structured so that the customers are selected
from a max date in the first query.  The second query,

My report has a field that sometimes might be null.  I've set that field on a
second line in my detail section.  How can I prevent the white space from
appearing when I print, whenever that field is null?  --
-- Gary

I am using Access 2000, but I am new to the product.
I am following directions in a textbook to create a
mailing labels report using the labels wizard.
I can complete all the steps, but when I hit the Finish

I have imported a table created by another containg a text
field with city names typed in in all upper case. I would
like to design a report that converts the upper case for
the cities (some having three words in the name) where the

I have a form which allows the user to pick and choose
fields.  This form also have a command button which pulls
up a report.  The report has a text box who's record
source is created based on what fields the user selected

I have a report with 1 Grouping.
I want the report to print seperate pages for each Group,
even if it is only a few lines to then just start a new
page for the next Group.

I have a report that shows a repair date and repair ship
date and I want to do the difference between both but only
the working days (excluding weekends and holidays).  I
found something called networkdays but can't get it to

I tried to post standard deviation on my report but the
following syntax does not work (Report shows #error.).
Could anyone do my a favour to check what is wrong with my
syntax:

need your help,
i have a report that have group footer for sub total,
it results 4 sub total item (A,B,C,D), which have
different number of records ie. 20, 40 , etc.I Details.

I have created two reports in my database that retrieve data based on a date range and complaint codes (1-6) on a form that opens when the main report is opened.  The main report is "Critical Issues Details" and the second report is "Critical Issues Summary" that shows total ...

Good Day:
I have a report based on a crosstab parameter query. The crosstab is getting
it's data from another query that has a field for date of data input
(datInputDate). The parameter input value is the year portion of

I have an Access 2000 database that seems to be working fine except for one
thing - when I try to run a particular report I get an error (MSAccess.exe
has generated errors and will be closed by Windows).  I've tried compact and
repair, running the /decompile switch on the DB, and ...

       I want a datasheet view on a report.  I stuck a subform set up for
one in the detail section of my report.  In the report's Open code, I want
to run some code settnig the form up.  I get an error when I run the code
line:

I have a report based on a table that is comprised of Field1, Field2, and
Field3
I'd like to have textbox that will display "Field1, Field2, Field3"  (as
quoted).  Any of those 3 fields can be blank (all of them can be blank as