I am working on Financial Portfolio Reports.
I have 3 reports. All Idendtical except for "Sorting and Grouping". Just
different names to the report. Each is sorted differetly. ( by Par, by
Ticker, and by Pct Owned) They all use the same query which has a

I am trying to count more than one type of entry to be entered into a text box.
For example I need to have a total of all types of Officers (Lt Col, Maj,
Capt, Lt) in one text box and a total count of Other Ranks in a seperate text
box

I have a report that gives me the count of the status of individuals .  This
works fine as long is there is only one record in the query (in my query
there is one record per month).  When I query 12 months  (individuals may
appear in various months) it counts each record of an ...

I have a report with a number of subreports (up to five subreports).
Many lines are blank, and I use the Can Shrink to take up the spaces.  This
works fine when I have two subreports in my report - the second moves up the
page as it is supposed to do.  However, when I get to three ...

I know when you set the Can Grow property of a text field, the field will
grow causing the record to expand, when there is much data for the default
setting of the text box.
Is it possible to make the other fields in each record expand to the same

I am trying to save a report as a pdf file in Access 2007.  I have previewed
the report and clicked pdf or xps.  When using the full version of Access it
works fine.  But when I am running this in a runtime version I get the error
"can't save the output data to the file you've ...

I am opening a report listing the sales for a given client.When however there
are no sales for a given client, the report is opened indeed but it is
written error and the picture is rather ugly. Could i set up some filter on
opening of the report, and if there are no data,just not ...

I am creating an invoice where each product is totaled in an unbound
textbox call [LineTotal]. Here is the complicate part. The total is
based on certain conditions. I was able to do it just fine on the
form, but am having a hard time getting it to do it in the report.

Hi, I am having difficulty with control boxes and parameter queries.  I have
created a report that is based on a parameter query.  When executing the
report, the user gets prompted 3 different times so they can input an agency,
beginning date, and ending date.  The report then ...

Pls help an access newbie ;-)
I am using access 2003
I created a tabular report using the wizard, based on a Table
Preview of report page : layout & values  => OK.

i have a report that needs to calculate a total bassed on user input. Ex.
assigned = 1 attached = 1 and detached = -1 i need to total the values
together i'm either doing my iif wrong or going the wrong way about it thank
you for your time

We have several members living at each address, but they move around
independantly of each other.  
I have been asked to create one report (order form) per member address that
would contain the names of everyone in the household on a single form.  I

This one seems a little bizarre:
At the OnFormat event I re-set to heights of some fields in the detail
section of a report based on certain criteria. I keep a running total of the
overall height of the section and, at the end of the event procedure, re-set

Is there a simple technique to get the number of lines printed in the detail
in the header rather than the footer?
Thanks.

I have a report set up where I've set the grouping and sorting to:
Team Name
Title
Full Name