I need to place an object on a report containing Sub Reports.  How do I add a
static - absolute position for each page as the sub reports grow to 100s of
pages?

Ok, I have a date field.  I only want that date field to print out of there
is something in the corresponding action field.
I set up a 'iif' statement in the data field (like I do on tons of other
things) and the conditions are working just fine, but the date shows up as

I have a report and a subreport. I would like to sum a field on the subreport
and put it in the Grand Total area of the main report. I have tried the
following and it doesn't work.
=Sum([Reports]![rptSumDowntime]![srptSumDowntime].[Form].[SumOfMechanicalDowntime])

I am trying to prepare labels in MSAccess 2003 Reports.
I have a group called Stores and each Store has a different number of
customers. Therefore, if store 1 has 3 customers then the next group starts 3
records later. If Store 2 has 5 customers then the next group starts 5

I'm having trouble getting ride of the border around my list box on the print
out. I have set the list box properties to transparent border and it does not
show up on the print preview. When I print the report the border is still
there. Any suggetions?

I followed a link (in this forum) to the following code to concatenate
multiple fields onto one line, separated by commas.  It works perfectly as
along as the field I'm trying to combine is a Number (double).  The problem
is I am pulling this info from a third party database that ...

I have two tables with these pertinent fields:
tblProfiles
txtProfileID (PK)
txtDescription

Have Access 2002 dB with reports based on queries, and VBA form to access
reports.  When attempt to preview some reports, report hangs, shows only
"Formatting Page - Press CTRL+BREAK to stop".  Report never displays, and
Access hangs.  Recordsets being returned are only 125 ...

My request is a simple on, I hope, at least for the info on a  report.  I
would like to be able to have a report that will print out the table name and
the fields located in the table.  Can that be done?  If so, how?  I know
about the documenter but all I'm looking for is the ...

Is it possible to run a query or to list all users currently in a secured
database?

I have a report that seems to be working well except that it has blank pages
inserted between each legitimate page.  The report is 98 pages long if it
were to print correctly, but if I were to print the whole thing, 196 pages
would come through the printer.

I have a report that prints (and shows on the computer) blank pages between
each numbered page.  For example, between pages 1 and 2 is a blank page,
between pages 2 and 3, and on and on.
Is this because of some setting?

I want to create a report that lists all available working dates between on
a start date and end date. These start/end dates will change each month. I
don't want to create formulas that adds 30 to the start date etc because
obviously not all months have 31 days and then there are ...

I have a database that was created in a Windows 2000 environment on Access
2000.  My company is currently migrating to Windows XP Pro and Access 2002.  
For some reason, the margins on some of my reports keep resetting themselves
so that it takes 15 pages to print one page worth ...

The charts row source is the query I built with the employee ID, Healt
Benefit %, Other Benefit % and the Salary %.  It is grouped by th
employee ID, and the %'s are Sums.  Should I change those to somethin
else?  The Link Master/Child properties are the employee ID, which i