All employees have their hire date listed.  As well as all of the training
history during their employment
I would like to create a report that only shows the training each employee
has taken for the 12 months after their hire month.   For Example, I was

I want to make sections of my report visible if there are records available.  
How do you access the fields on a report.
Here is what I am trying to do
If (DCount("TugID", "tblAnnex", "TugID = " & Me.UnitID) = 0) Then

I've designed a 2-page report and I'd like to have "Page x of y" printed at
the bottom of each page.  so, if I was running the report on 2 records it
would print 4 pages, with the first one printing "page 1 of 2" at the bottom,
the second page printing "page 2 of 2" and the third ...

In my report I have a footer for the total. The database is design to keep
track of all vehicle accidents that happen and if they are access driving
points it should total each employee separately.  Example
On 3-9 John receive 4 points for careless driving and on 4-8 he receive 2

I have several reports with multiple textboxes arranged vertically that need
to dynamically "stretch" to accommodate variable lengths of data (and I
CANNOT concatenate the text):
Col A      ColB      Col C

I created a report using the Reprot Wizard. During the process it
allows you to sleect the fields to group data by.  Since having
created this report and spending some time formating it, I have
realized I need to add another grouping field to present the data as

I’ve run into a problem though while designing a report and I was hoping you
could help me out. I’ll try to explain it as clear as I can.
I have three different accounts that all have transactions of revenues and
expenses. I wanted to sort the data from the account for the last ...

In an Open event for a report, I can set the Caption of a Label, but not the
text of an unbound textbox - produces the error "You can't assign a value to
this object."
Happens in both A2002 & 2007

Are there any way to change report after design?
I design a report as lanscape and would like to change to portail.
Are there any property to change it?
Your help is great appreciated,

I have something odd happening with word wrap for text fields in a report:  
Word wrap is not consistent.  For this text field the 'Can Grow' property is
set to yes, and the field wraps, but it often cuts off the end of words.  
For example, the text "No charge work order (WO ...

In a chart I'm showing the data table for multiple series. What I want to be
able to do is move my series in a specific order in legend. I can't get it to
do what I want by changing my Row Source. How would I order a legend in data
table ?

I have a report with a group which has a row source of
SELECT tblDivision.Division FROM tblDivision ORDER BY tblDivision.Prefix;
It's supposed to be sorting by the field "Prefix" which is in the
tblDivision, but it's sorting alphabetically by the field "Division". What am

I want to export the screen active report to xls format. I am trying the
following code, but failed :
Function ExpoXLS()
Dim rptCurrentReport As Report

I am getting a missing operator error when trying to print as per the code
below.  The Cert_Rec.CustodyNumber & ") " variable was changed from a number
to text Cert_Rec.CustodyNumber & "') "and in doing so I get an error.
What am I missing??

I'm trying to create an Access report to fill in columns and not as rows. In
this case a report with data columns is easier to read and organize. The
query feeding the report will have only a limited (5) returns/columns max so
there will be plenty of horizontal room to take the ...