I've included a DCount in my report and I'm trying to determine if I can
reference the "value" of a report group as part of the criteria in a DCount
function.  I'd like to count the number of records in a table where the
value of a field equals the value of the group.  My first ...

Does anyone know how a way to check two different Access
Databases to make sure that the table structure is the
same? I am using Access 97.

My query is:
SELECT Count(Customer.Suffix) AS CountOfSuffix,
Customer.Register, Customer.IDProfession
FROM Customer

I have a report from a query that gives me dollar totals of shipments by
Vendor and Part Number per month.  The date in the query is set as follows:  
"Format$([ReportSubVendorDollars].[ShipDate],'mmmm yyyy')".  This gives me
the results I want but in the report it is not being ...

What help can someone give me on footers.
I would like to keep a group footer from printing by
itself on the page following the detail.  Using keep
together does not give me the results I want.  I want to

I am creating a report from a crosstab query. The query
is working great. I can select a StartDate and an EndDate
for parameters.
When I create my report and run it, it asks for the

I have been working on a report based on a date. I have
resolved all the problems except one. I want to run the
report from a command button on Click event. The date
will be entered into a text box and formatted mm/dd/yy.

I am running thisreport and all of my pages are coming out
blank, what are the different reasons for/fixes to this
problem?

Is there any way to put some totals from multiple queries
in the report footer.  
Every time I try to do it I get a parameter asking for
data.

   In my access database (not an access data project!)
I'm trying to create a report based on a SQL Pass-Through
Query called spReportRequest. 'spReportRequest' is a
stored procedure with parameters: @ReportId and @loc.  

I've attached my coding below from a text box in a report.
It's giving me the first initial of a persons first and
last name. It pulling three different field name and if
all are null then the word Agency is filled in, if not

I am having a problem sending this simple WHERE clause in my openreport
command:
DoCmd.OpenReport stDocName, acViewPreview, , , "[InvoiceDate] =#" &
Me.cmbInvoiceDate & "#"

I have run into an odd problem, in my report I have to 2 subtotals - one for
each grouping.  my first grouping counter works fine - which is the 1st
grouping in which I add the "RecordCounter" =1 and do a sum over group, then
set the total for the grouping equal to that.

The following article
http://support.microsoft.com/default.aspx?scid=kb;en-us;208696&Product=acc
shows how to print a blank line every nth record.
That doesn't work if applied tio the detail section. any clue?

This is a continuation of an earlier question, but I have
more information that may help.
I have a "detail" table that uses a couple of "master"
tables, mainly to link to descriptions.  I can create a