I have three text boxes in the header section of my report.  The 3rd  one
(Text58) is suming the other two text boxes (=[Text51]+[Text54]).  In my
report Footer I'm trying to add up all the results of the 3rd box. In the
control source of my footer I have =sum(Text58).  I don't ...

I have a report based on a Table, which has 6 Fields/Controls.
I have Grouped on a particular field, it is ok, it groups and the data
related to it views in the details section.
Now I want to sort (sort only not group)the detail section based on a

How do I create a report which prints only one record in my table on a field
say "PersonName" which contains a value passed from a database lookup?

I have a report wiht a chart (Microsoft Graph 9.0 Object). I want to change
some properties of the chart dynamically when the report opens using VB (like
whether the chart should show values above the bars, and whether the values
would be in precentage or absolute values). I ...

Hi all and thanks for any help with this.
I can't seem to get this code to show more than one report in preview.
There are 18 owners so there should be report previews? I believe the code
is working:

I have two querys "Wages Query" & "Expenses Query" which displays the
following values
Wages Query                                              Expenses Query
Month                 Amount                               Month            

I have a report that has 6 columns
Rank, Last Name, First Name, Number, Recv Date,
OrigUnit,Restrictions,SingleResponse.
The report is the above (6) columns with 164 records (rows) of data.

The issue is repeating the same record on a sheet of labels, like a return
address.  I am querying one record from database table, then printing an
Avery sheet from a designed Access report with the same labels.  Otherwise, I
will have to export the answer table to Word and merge ...

I have a report based on a table that has several "deadline" date fields.
Preliminary Review Date
Department Staffing Date
Command Review Date

My data base consists of numerous records and each record contains the
answers to 15 questions. Each question could have an answer of "y", "n" or
null.  I need an overall record count of the entries spreading the three
possible answers for each of the 15 questions.  I'm not ...

Hello :-)
Using MS Access 2000, I based a report on a PARAMETER query, not realizing
the Domain Aggregate functions would then not work and So, to display the
total number of records for each [gender] i used...

I am trying to display a date range on an Access report that is determined by
the user at the time he/she runs the report. The user inputs a start date and
an end date, the queries then run over the given date range and then are
presented in a report. I would like to display the ...

I have a main report with a subreport, linked via primary and foreign keys.
Not all records in the main report have any detail in the sub report but for
each record it shows either the details as it should or a space where the sub
report sits (empty space when there is no related ...

I'm wondering if i could have multiple subforms developed, then present user
with dialog, and construct a report at runtime by including combination of
subforms programmatically, based on what they have chosen to see..perhaps to
a blank master report..?

just want to know if you can put a series of 3 or more queries that will give
you total sums of data to code? First I pull fields from main table, then I
group/count, then I run a crosstab to get totals only.