Hi.
With help from this Discussion Group, I have set up a way of counting
records in various Report sections. This works fine but I’ve just noticed
that it includes, in the count, records where there is no data in the

I have a question that hopefully has a simple answer, however I am completely
stumped. I have a query that returns data from a table like so.
Account_Code       Invoice_Number
        1                      AB12345

I have a space between the header and the details and I cannot figure out how
to remove it.  There is no space in design view.  I have tried removing the
last row of labels from the header and moving the details bar upwards and the
space is still there.  The details have lines ...

I am trying to create a report and I keep getting the following error" The
wizard is unable to preview your report, possibly because another user has a
source table open in exclusive mode.  Your report will be opened in design
view" can you please tell me why I am getting this ...

Hi.  I've had great luck with creating a query that asks for user input (say,
letting the user select the state), and then having reports run based on that
user input. But now I have a more complicated situation and I'm wondering if
I can do something similar.

I have a report based on a quary from two tables. Each record is printed on
a separate page. What I want is not to print the records with empty fields
(the selected fields from the query). So when I print the report, it only
prints the pages with data on.

I have a 2003 Access db using an MDE file as the front end on a local machine
with the backend on a network server.  When the user goes to print a report,
they are  prompted to install a printer and can't.  Other reports print.  All
reports and subreports are set to use a default ...

In the detail part of a report I would like to show the sum the data for all
the records which have more than 2 fields in common.  The report is based on
a query.  My fields are Genus, Species, Location, Quantity.  I would like my
report to give a single result with total ...

I would like to create a report in Access 97 whereby the user can filter in
one field to select one of 18 alternatives. The report is to provide details
appertaining to that selection, or to all items. Can anyone advise please? I
am fairly inexperienced at Access.

I am running a report with each entry containing 12 fields. What I would like
to do is have the the report automatically not include entries when they are
missing information in one of the fields. Access 2000. Thanks.

I have a report that I would like to determine if a given field is empty on
close.  I have the following code;
Private Sub Report_Close()
Dim strID As String

I have to build a report that replaces a paper form.  Part of the
information is stored in the access database but part of it still needs to
be filled in by hand.  I can create the form but I the problem I am having
is that I would like to have some blank lines on the form that ...

I would like to produce a report based on one record from the many in my
database.  The database holds records of customers, andI need to print off
separate reports for each customer from time to time - but never all at one.  
I'd like to create a list box, or combo box, from ...

I have a report whose query contains the following criteria:
Between [Forms]![fdlgRpts]![begdate] And [Forms]![fdlgRpts]![enddate])
Within the report I have a field that counts the following:
=Count([AssignDate])

I need to passa value from a form to a report.  Whenever you click on a
the command buttonon the form it opens a report and passes the value.
This is what I have but it doesn't seem to be working.
Reports!UnpaidChex!Tax  =  Forms!Reporting!TaxRate