In a blank report, I would add a label.  Then I go to the properties of that
label and set the Hyperlink Address to, say, a table or a query in the
database.
When I open the report, the label looks like a hyperlink (blue with

The rows of my report contain enough data to overflow onto a second page.  If
I select legal size paper, all of the data would fit onto two pages nicely.  
However, when I choose my column width (1 column for whole report) in the
page setup menu, I am limited to only 22" instead ...

I would like to create a report, which shows variables as
row and records in columns, a kind of like 'TRANSPOSE'
function in EXCEL.
Can anyone could provide advice? Many thanks.

I am using MS Access 2002.  I created a chart on a report.  In the design
area, the chart shows default data only, but I want it to show the real data
in the design area.  Can I refresh the design page somehow to load in the
real data for the chart?

I have a text box that I would like to set visible to False if the field is
null.   Normally this would not be a problem, but I have set the border style
to solid and border width to 2 pt., which means I have big emtpy boxes on all
my records.   This defeat the reason I have set ...

Aceess 97. I need to send reports by email. The reports received do not look
the same as sent. Is it possible to send the report so that it looks exactly
as , or if printed, looks exactly as if printed from the database? Someone
suggested that I should send it as a .pdf file. How ...

Using VB, what is the code to open a report window maximized, with view at
100% and centered. Right now I have the following code:
Private Sub ProducerInput_AfterUpdate()
DoCmd.OpenReport "Producer", acViewPreview

I have this report that is setup to preview and print in the landscape
orientation.
Now and again I get this problem where in preview mode it shows up in
potrait orientation.

I have an Access program with report which using unbound field
for the Total grouping
I put the calculation in the OnPrint event in the Group Footer
Let says I generated a report with 3 pages on a Print Preview mode

I have a simple db with some 8000 records and an external folder with
filenames. I wish to get these names into a Pathfield in the main table so
that for each Record# the appropriate filename is fed in the new Pathfileld.
The files are images with names like xyz????.jpg where ...

I have developed a database that uses excell to crunch numbers then spit them
back to Access. But no matter how I format them in excell the fractional part
always comes back as a decimal in access.  I've tried making formatting the
cells for text, text using =TEXT(), quotation ...

I am using Access 97 and I have a report based on a query "qryInformation".  One of the controls is a "value" field from my query.  It's the value of an item in dollars ($150).  I want a control on my report that will give a sum of all of my values.  I created a query based on ...

I have a control on a report to give me a unit cost and this involves the
expression "=[Text19]/Val([Unit])".
This to extract the numerical part of a field so this can be the divisor to
give me a single or unit cost.

I have created an Access 2003 report that calculates a percent achieved
towards a goal.  The report itslef is rather complex.  It pulls in values
from other reports as well as caclulating totals, averages & projected finish
at the end of the quarter.

How do I add a Sub Report to an existing Report?