I have a sales report that compares January 2005 sales to
January 2004 sales.  I created a column in my query
called change in which is calculated the percentage
change in sales:  (Jan05-Jan04)/Jan04.  Several of our

Can an Object Shrink and Grow in a Report? If so how do i do it?

OK,
Maybe one of you Access geniuses (MSAMVP) can figure this out...
I have an Access 2000 database linked to a huge Oracle database.
My company's fiscal month is the 22nd of the month to the 21st

I've got a report with a couple of sub-reports and when I view it, it shows
on the top-left of the sub-reports (on top of other text that has to be
displayed) a name which could be the name of the sub-report or the name of
the query that it points to. Does anyone know of a way ...

I created a report with columns in it but it for some reason does not
repeate the Page header on the other columnss and the page footer is only on
the first column aswell and i would like the footer to be accrose the
complete page. If some one could help me please.

I know how to insert a Page Break.  However can it be done so under a
certain condtion to do a Page Break other wise for the other pages not to.
Any help would be greatly appreciated.
Thank you,

I've built an Access 2002 DB that I use for my Old Time Radio shows. I have
a report that list of all the shows for a given series including broadcast
dates, episode numbers, titles and the like.
The query that the report pulls from also has other fields including a

I have a report (data based on a query) that is grouped on the following:
Date, Vehicle# and Trip#. No headers or footers
When I print the report it may look like this:
Date:        Vehicle #:            Trip#:

I have a form/table for customers and one for orders. They share a common id.
When I run a query to join them, I get multiple records for each customer
depending on the number of orders they have placed. Is there a way to have it
only return the last 5 records with the most ...

I want to open a report RptCustPricelist to display the specific customer
showing on the FrmPriceList.
I am using the following code:
***

OK, let's take a different tact with this problem.  I have to make a report
to show the following:
Aircraft Number  Jan   Feb   Mar   Apr   May   etc...   6 mth avg   12 mth avg
162316              9.7   92.5  45.4  60.1  75.5   etc         ##.##        

Tell me this.... in MS Access Reports, can you use the 'SUM' command to
produce the total of partiular fields?
Thanks,
Paul

exactly how(if possible at all)do i put a border around a report i created in
design view, i am an A2 student and i'm trying to stick to my origional
design but if i can't put a border on a report that changes everything!

I'm using the formula =DLookUp("fieldname","[query name]"), which has been
working fine, but now I have a field in the query that is "0" and the report
displays "#Error".   How do I get the report to display a "0" if there is no
value in the query?  I'm using the "lookup" because ...

I'm using a customised version of the Time and Billing sample database
running on Access 2003.
I have a default printer set to a local color inkjet printer and that
all works fine (my reports have some colored lines as well as a small