I have a report that is grouped by employees with costs associated to each
employee.  I am trying to count the number of employees in the report footer
but =count([EMPLOYEE]) is counting all the records not just the number of
groups which would be what I want.  The label and the ...

I have a report design where names are listed down in
columns.  I have provision for several fields in the
design view, but sometimes these field are blank in some
records.  When I run the report, it allows spacing for

I'm having trouble viewing reports within MS Access XP Pro SP3 installed on
my new laptop with lots of storage.  OS is Windows XP Home Edition.
Here's what's happening....
This is the first I've ever seen this kind of problem.  Cannot find anything

How in the world can I get the average for several blocks
of data in the row.  Not for the column.  I need to show
the average flight hours for our aircraft over the last 6
and 12 months.  This is driving me crazy.  I've looked up

I need to create a single report from 3 unrelated queries.  The queries each
have a different number of columns and records.  I tried using the report
wizard, it let me select each of the queries and the columns I needed from
each, but when I hit finish, the wizard tells me it ...

When I run a report, I want names of people in a particular department to be
underlined leaving the rest not underlined.
The code I wrote, that does not work, is
Private Sub Report_Open(Cancel As Integer)

I wanted to print a form, so I created a report that looked similar to the
form.
I've created a command button on the form where I want it to print the
report based on the current record on the form.  How can I code this into the

Is there a way to keep the detail section of a report together with its
Footer (so they both print on the same page)? If both do not fit, they should
BOTH go on the next page...
Thank you,

I have a fairly simple database with only one main table for data. I have
three basic reports. Right now I have about 25 different reports based on
each basic report, the only difference is that they each either have a
different query as the record source, or that they are sorted ...

I display page specific data on each page header and want to suppress it on
the report footer.

i have a table that contains: username,date,timein,timeout.
everday a new record will be inserted.
at the end of the month, the system should generate a monthly report that
contains : month name, username,date,timein,timout.  also the report should

I created a report using the report wizard.  When using
the wizard, a footer is created with the =Now() function
and today's date is added to the footer label or text
box.  Actually, what would that be considered?  A label

Thank you for everyone's help in the past.  I posted a
message on the board a few days ago and it's not
resolved.  Sorry, but this is driving me nuts and I need
to finish this report.  I'll list the postings.

I am trying to brainstorm an effective way to let users create their own reports possibly without using the wizard (I have many tables and queries and the user would not know which to choose from), and also without saving the reports.  
I could precreate reports for users, but ...

I have a subreport which is formatted for 2 columns & it displays correctly
when viewing just that report. I have this as a sub-report & it won't display
columns. Any ideas?