I have a report which groups statistics by year. In the detail section I want
to put an unbound control that totals the numbers in the field Elevation from
the table tblMoreStats for the year shown in the grouping header. Would like
some help if possible. I have tried ...

I have a data set of scietific data similar to [TestScore] vs. [Age].
Using the chart wizard to make a line graph, the y-axis (test score) is
perfectly spaced by 5 points, or 2 points, or whatever I set it to be.
The trouble is the x-axis.  I have my query grouped by age so I can ...

   I was wondering if it is possible to display labels in an Access report
upside down and etc?  I have looked all over the place for this and all I
have found is a third party product which kinda does this.
Frank

Hello to all,
Is it possible to change Report Headers from a form using a global variable.
I would like to use the same report for A, B, and C clients instead of having
three different reports.

I have a query that groups daily entries monthly by the date (i.e. 1 for
January, 2 for February, etc). When I create the report the report
recognizes 1 as December instead of January, thus my data looks like it is
one month behind. Any ideas why?

Is it possible to set the paper size and/or orientation  
in code based on the number of records in a report?

Another one for me today!
I have a report with this Record Source:
tblPKProjects.TargetCompletionDate, tblPKProjects.Description,
tblPKProjects.Priority, tblPKProjects.Objective, tblPKProjects.RequestedBy,

I have several reports that need to print in landscape.  
Several times, I have changed the page layout for each
report.  It works for a couple of times, but inadvertently
reverts back to the portrait print.  I don't want users to

Can anyone tell me why I can't change the top property for a text box on a
report?  It accepts some numbers, but I've noticed that they're relational in
some way or another.  One more catch...I don't know code.  Anyone who could
help would be doing us a huge favor!!!

I have a report that shows component quantites for different devices.  This
for will check to see what is on hand and how many we need for the quantity
that we are building.  Is there a way for this report to show the negative
quantites in a different color than the positive ...

This is a message for Duane Hookum who has been helping me with a Dlookup
problem.
Duane - I cannot get into Tek tips to get your last message. Could you post
it in here for me?

I have several applications with the same coding and no problems.  This one
application intermittently loses it's mind.  I have reports that I want the
date to appear on so that the date the user runs the report is reflected.  
It's always worked in the past, but now when I go to ...

the report that i am having trouble with is based on a query that works off
of a table and another query.    the first table, TBL defect count, has a 1
to many relationship with the second table, tblDefects.  the child query adds
together several records from tblDefects.  for ...

How do I get the Label Wizard to accept four lines in a Avery 5160 address
label? This should be a no-brainer but with the newer Access, I have to
redesign the label every time.

Using A2K.  I've got 2 reports that I want to print one after the
other.  Below is the coding:
       DoCmd.OpenReport "rptBilling_FutureCharges",  acViewPreview
       DoCmd.OpenReport "rptBilling_Summary", acViewPreview