I have a report that has multiple headers in it and when no data is in one of
the headers it leaves a big space in the report. How do I get the header to
reduce in size if no data exist is the fields on that line? Thanks for any
help provided

Is there a way you can print  mailing addresses directly onto envelopes?  
Also, if the envelopes are fed length ways will the system allow for this?
Thanks for any help
Roger

Me a novice and have a question that I hope won't confuse everyone further.
what I am trying to achieve is retrieve the demographic information of all
participants in a reserach study who meet certain criteria like may be
cholesterol level > 250 or who have diabetes. If they do ...

I copy an existing report and give it a new name, however when I try to save
the new report it ask me if I want to save it using the report I copied from
and not the new name. How do I copy and save my changes under the new name?

How do i get my page setup on my report saved. It seems like it is not saving
. Everytime a user  generate the same report, it does not have the same page
setup i defined previously. The system is on a multi user environment.

I am putting together a very simple report to capture missed freight on Sales
Orders.  I want the report to have a running accum of total amount of freigt
missed and I cannot seem to figure out how to sum them up in the footer of
the report

Any help on this greatly appreciated.
I have built a database for a small carpentry company.  I put all of the
customer information in one table.  Project Information in another table.  
Materials, Labour, and Incidentals each in a table.  I have related them by

I have a report based on a query that has criteria for one of the fields -
category.
I want the report header to display the category from the criteria. I can
get the first one but if more than one crieria is used - I cannot get a list

I somehow cant get my sort order right.
The sort order of my RecordSource is not reflected in my report, and when
setting the Order By and the Order By On = yes, it still doesnt work.
The report was originally created with a wizard, and here I may have

Respected Sir !
I am using access for my works in office . I am going to do immigration work
in which I have to enter passport details , Visa details & laborcard Details
so I want to get report according to current month & year . I tried but i am

On my Main Menu you select a button which list all the reports (in a list
box).  You can double click on a report name in the ListBox (located on the
Main Menu)  and the report goes into preview and maximizes (and, yes I do
need it maximize):

I have a fairly large access application.  It is split FE/BE with the BE
residing on a Novell Network drive.  I have implemented most of the
performance hints that are suggested and overall the app is/was running fine.
However, due to needing International currency symbols, I ...

i want to open my reports in the same format in execl as i see in access...i
want same kind of allignment ,headings,...exactly the same way..(horizontal
and vertical wise).. is it possible? i hope u understood my problem plz help
me out..waiting for rply

Following is an example of my query records(there are actially several other
RL's and Actual, BT, N and S fields in the query.  This is a sample):
RL, GoalDate, DActual, DBT, DN, DS, OnActual, OnBT, OnN, OnS
MM,   1/1/05      10      5     10   15     8             10     8      5

I have a report that is run off of a sorted query.  I want the report to
break on a different field than what the report is sorted on.  However, when
I setup the break it re-sorts the data on the break field.  How can I keep
the data as it is pre-sorted and break on a different ...