I have a report that is working ALMOST perfectly.
The report is setup as such:
Header had Order# and Order Date
Group1 creates new page for each Category within a group

I am trying to create a sales report based on sales
figures from 2001 to present.  These figures are monthly
percentages, so for every year I have 12 figures.  I am
trying to create a line chart to represent the data

I have a table (tblComments) that I am using in a report.
I have a list of standard comments that I would like to
print out and distribute to our employees. I would like
the report to look something similar to this (currently

Is it possible to do this?  If so, how can I take a query
that has these fields as Coloumns (across the top) and
make them rows in a table?  For instance, I have Apr, May,
June etc. along the top with a Sales figure below it.  How

I have a report which has four different fields that have
contact names for data. Then I have a field for a customer
name for data. And the last five fields are filled with
dollar amounts for data.

I have converted a .mdb from Access 97 to Access 2003 &
Iam having problems bringing up a Prtint Preview with
this code 'DoCmd.OpenReport ReportName, A_PREVIEW'
causing error 2501 - 'The OpenReport action was canceled.'

Say I have two text boxes in DIFFERENT FONTS (so as far as I can tell, I
can't just make them into one text box), and I want one to have its left
edge at the other's right edge in a report.  Basically I want it to look
like this (view this in a fixed-width font or it won't look ...

Can I have a textbox and the data in a report show up contingent upon another
field? For example:
I have several groups of items and I sum over each group. I only want the
sum to show up for certain groups, but not for others. Can I make a textbox

Is there a way to create a calendar using my events data in Access 2003?  I'm
trying to create weekly and monthly events reports with no luck?  
Thanks in advance for any help

I wish to thank fredg for helping me with thes subject earlier, but I need
further guidance.  I need to do the same thing to the unbound text
(=Sum[grantT].  If i Substitute the above text for the FieldName that fredg
gave me I can't get it to work. can someone help me or have I ...

We have a user who is trying to create a report with conditional page breaks
based on a chapter number changing. Does anyone know how the following can
be done?
"I've taken an excel grid of thousands of lines of data, imported it into

MS Access, Windows XP
======================
Hi,
Is there a way to change the label number in Report design

I am trying to get my Access 2002 reports to display the report name on the
footer.
I have tried (1):
=CurrentDb.Name

how can i print first page of my report in letterhead
and the rest in ordinary bond paper..
the record source are grouped

I've created a report that groups daily sales data and
sums by week under group footer.  When I try to sum the
entire month of sales at the page footer, I get an error
message.  Can anyone help  me with creating a report that