I've been trying to create a report giving total expenditure by category for the last six months, with a column for the six-month average (including in the average any month with $0 expended for the given category).  That is:
          5 months  4 months   etc.                ...

Has anyone tried to develop a matrix report from Access.  I would like to do
something like that but have no idea where to start.
What I want to do is have a list of projects on the vertical access and if a
task exists for that project put an X in a box on the horizontal access.  ...

I have a mailing list - table, where the state field draws from a look up
table(combo box) with the two initial state abbreviation. Each state was give
an id # within this look up box.
As far as I can tell, the db structure seems solid.  The forms display the

Before I was forced to switch database to Microsoft DAO 3.6 Object
Library compatablilty the following code maximized a report when
opened (connected to report's On Open)
Private Sub Report_Open(Cancel As Integer)

When I publish a report (A97) to Word I loose my lines and logo.  Is there a
way to have these changes carry over to Word?

With Steve help I got this code to work yesterday and today not!?; is asking
to install a printer on th output line!
Any idea is greatly appreciated,
Thanks,

For strange that it sounds I need a report to be available only in print
preview mode. I mean, the user must not be able to print it neither by the
menu nor by Ctrl+P. Is that possible?
Thanks in advance.

Every time I try and open an existing report or try and create a new report I
get an error message that closes out Access 2003.  I've tried repairing
office, reinstalling office and still get the error message.  I've searched
through every possible error message and no solution ...

I am a new Access user and am having trouble getting a report to update every
time it is opened. I have tried to use the reguery command in the "on open
event, but this causes the record bound for the report to change.
Is there a way to requery a a report before it opens and not ...

My report lists scholarship recipients in the detail section.  Sometimes the
list contains student names from more than one campus.  In those cases -- and
only those cases -- I would like to make the campus code visible.  How do I
get the format process to look ahead and ...

I have a tabular report, one row of fields in the detail section.  When I
preview/print, the rows appear double spaced.  I tried using FORMAT-Vertical
Spacing, didn't work.  I also checked the Line Spacing property, which is
0.???

i need to have popup after the 'print report' button is clicked that asks the
user how many copies of the report they want printed. any suggestions?
thanks in advance,
frank

Change a number ($10.32) to text (ten and 32/100) in Access.

The info goes into the database through a subform as shown below:
Lot#     Lot Amount     Lot Value
100      50             200
101      50             200

This query was originally put in the RecordSource in the report's properties
sheet.   The results are good and sorted by Year followed by month.
I modified the report and to put this query in code in the on_open form
event and have the Report.RecordSource = strSQL.  The results in ...