Want to compress Access report which prints out double spaced.  Want to print
out report in single space.

is it possible to get Access to create an org chart from
the data stored in it.  ive created a database to track
the manning and establishment of a company but want to be
able to produce org charts from the data?

I designed a database and used the button wizard to create a button that uses
the  eMail command to place the report into an eMail.  The only problem is
when I click on this button a pop-up asks what format I want to eMail.  The
options are RichText, HTML, SnapShot, etc.  No ...

I have an application that needs to switch between printers programatically.
In effect a workstation could have up to 3 printers on it. One for reports,
one for big labels and another for smaller labels.
The MS Access 2000 application in place now uses OpenPrinter, SetPrinter and ...

I was wondering if there was a way to simulate a gannt chart using access
charts. I know they are limited but is there an add in to enable me to do
this.
Otherwise can i export to another program to create one?

Printing trouble: How do I fit all columns of my table on
to my page of a print-out?

I have a report which has six columns. I need to add a page footer to
record date of issue and page number.
When I do that I get one column at the extreme left of the page and
another at the extreme right. Columns also disppear. The number of

While making report in mdb we do the page setup/margin set
up and we adjust till we achieve the setting which we
want. The mdb reports page setting runs normal on the same
Pc. But if the same mdb is been installed/Run from other

Hi to all
My report needs to have the title OH & S Report.
Every time I try to input the Ampersand, the report
removes it.

What is the proper/recommended way to pass data, via VB,
to an Access 2002 report?  I want to be able to change
report heading strings, column labels etc etc.
I have tried several methods that did not work.

For an MDB database, I would like to base a report based
on Query 'PatientFollowUp-Dev':
PARAMETERS dteBegin DateTime, dteEnd DateTime;
SELECT WorkDay.ChiroID, [Chiro Name].ChiroName,

Can you right a count query in a control source of a
control on a report.  I need to run percentages.  The
script I have written is
=(select Count( [ar_trans_type_desc] ) from

I'm trying to build a report that will show an age in the years and months
format.  I have found a routine on the net but I'm unsure how to call it!  I
have tried     fullage: CalcAge([DOB],[now()])  in a query but not sure if I
have enough parameters and also how to handle what ...

I have 2 fields in a table: Item & Qty.  I'm doing a Label Report based on
this table.  How do I tell the report to print the number of Items based on
its Qty.  For EX, if Qty is 5, I want to print that Item 5 times.  I thought
about doing a VBA code to modify the table, but is ...

My clients have reported a strange reporting problem that occur very rarely,
yet it has occured at least twice.
It seems the detail section repeats itself twice one group right after the
other.  when I viewed the report the footer goes beyond the total report