I was wondering if it is possible to make a report like quickbooks.  When you
pull up a report in quickbooks, for instance,  payables....it brings up a
list of what you owe.  If you click on a particular bill the system will take
you to that bill.  Is this possible with access??

Why does the expression =IIf(IsNull([SumOfHours]),"0", [SumOfHours]) giving
me the answer of #Error on my report? I have two databases linked, and the
values are be pulled from the second database. If the assignment hasn't been
worked on, no hours are entered in the second ...

I have a table that stores many attachments to one entity. The attachments
are simply hyperlinks of files located on our server.
What I'd like to do is generate a report that automatically opens
attachments in their associated programs. For example, a .pdf file would open

I would like to go from one page in my report to another. If i hit page down
button i only go  the bottom of the page, i want to go to the next page. Is
there any way i can do this.
I would also like to find out were i can get a copy of the shortcut key.

I know I'm probably driving you guys insane.  I have footer sections set up
for a report that have label names not included in my tables.  When I open my
report I get parameter boxes for each label name ie. Total Specs, Total
sales, etc.  How do I get rid of these?  Do I need to ...

Trying to create new reports in an existing database as well as a new
database we have just completed.  Have tried using both report Wizard and
design view to create the report.  When we try the report wizard it allows us
to walk through all of the steps to select options.  When ...

Is there a way to print the page footer only on the 1st page of a multi page
report?

I have a field in a report that gives me the number of days from a certain
date for each item.  I need to get an average of the total for this field.  
What would you recommend?

I am trying to print postcards with Name and addresses on one side and
specific information of the addressee on the other.  When I flip the paper
over to print the other side, the data doesn't match up with the address.  

It would be great if I could have more than 22 inches of usable space on the
reports since I can plot to a large format plotter!!!  Just a thought!!
plus it becomes combersome when I try to plot I need to make a custom size
of 20x20 for example instead of the ansi or arch ...

My subreport, on its own, shows three columns when it is set to "down then
across."
When it is set to "Across then down" it shows only one column, with multiple
items all in that one column.

I have designed a report on Access 2003, and wish to export it to Excel. I
used a simple VBA code:
DoCmd.OutputTo acOutputReport, "Main", acFormatXLS, "C:\rptRounds.xls", 0
Unfortunately, the formats aren't being exported. For example, on the report

I have a report in Excel that the gouping labels are verticle on the left
margin, I would like to replicate this in Access.  

Can you angle a lable in a report?? Similar to a 45 degree angle to a cell in
Excel. and how. I seem to only be able to go horizontal and vertical
(Vertical text is backwards) Appreciate any and all help. Cheers

Is it possible to use the SQL SELECT statement in a report?  Here is the
statement I am using that doesn't work at this time;
SELECT tblAcctInfo.AcctName WHERE tblAcctInfo.AcctID = AcctID;
this is the control source for a text box named Text31.