I have a chart report that I would like to use as a subreport.
Currently it shows all of the data in the chart.  What I want is to
have the chart delimited based on link child and link master.
However, it is not working.  I have set the link for the chart itself

I have created a report with a subreport inserted.
They have separate queries that come from the same table.
I am trying to put a comments filed on the bottom of the page away from the
detail section.

I want to retrieve 10% of the records in a table, but want them to also be
randomly selected.  In other words, I want to randomly subsample a group of
records.
Does anybody know how this can be done, either in SQL or VBA?

Hey all.
I am creating a report from a queury I built and for some reason it won't
let me format one of the columns.  There is nothing in the drop down box
under Format.  Here is the expression:

I've got a text box in a report that's not returning properly. Here's
its Control Source:
=[Reports]![rptFGPackConfigsPKWeights]![srptFGPKConfigsSUPK_totalwt]!
[SumWtg]+IIf(IsNull([Reports]![rptFGPackConfigsPKWeights]!

I have the following code on the On Format property of one of my Headers on
my report:
Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
   If ChangePri = True Then

Hello,
I am a novice to Access and have created a report with a list of all our
entered request in our system sorted by Customer. Each request however shows
up on our report and I only want to see the last request entered. ie. (We may

Jeff Boyce MVP, put me onto a neat way of hiding or displaying fields on a
report, eg
If Forms!frmSpecialMakeResults![Frame108] = 2 Then
Me![Name3].Visible = False

I have a report where, when viewing unfiltered, SOME records will grow to 2
pages while others still fit on one page.  There is no visible data I can see
spilling over to cause the second page.  Also, it is not for each record in
the report, just some which tells me the margins ...

I have a report that I want to change any empty fields (textboxes) to have a
red background.  I cannot seem to get backgound colors to work?
If I set conditional formatting on a value < 10 with text color changing it
seems to work.

Periodically we email an Access 2000 report using snapshot viewer.  The
report is based upon user input varible date data which control the
underlying query and two text boxes that display the "from" and "to" period.  
When the report is previewed or printed, at the sending ...

When I create reports they are always oriented horizontally.  The column
headings and columns run vertically but each item in a record runs
horizontally.  I cannot find a way to rotate this 90 degrees to the left
where the record field headings run along the side of the report ...

When I export access report to excel, I'm getting overflow error at specific
page. I've checked for any errors like divide by zero and so on. But
everything is perfect. But Still I'm getting the overflow error. Can anybody
please help me on this?

I am setting up a report that pulls information from two differant tables.  
The data has a list of reasons that people have called our flor support
personal.  I am trying to to show the data grouped by reason type and then a
total number recieved per month.  The layaout should ...

How can you set up when you run a report to only pick a certain information.  
I have a table that has a drop down menu of locations, I would like to run a
report and when you go to run it it asks you what location you would like to
pick.  If you could please reply when you get a ...