I have created a line chart to reflect the total number of transactions that
have occured each month.  Over time this chart will become quite lengthy so I
would like to limit the bottom axis to the last 6 months of data. Can't for
the life of me how to make "Between Now And (6 ...

Is it possible to change the RecordSource property of a subreport? I have a
report that contains several subreports, and I need to change the
RecordSource of several at runtime. In the Open event, I have lines like
<subreport name>.Report.RecordSource = "..."

I have a database and I want to print it to Avery labels.  How would I do
that in Access?
thanks

I have a access program, that allows users to open different instances of a
report in preview modus, each instance had own data.
How can I do this?
I can create many instance of a report with

Can any one help? I would like for a label (Label32) on a report to be
Invisible unless a check box = yes. Can I use an If statement on a report?
Any ideas? Neither the Label or Check Box have any Event Properties, please
help!!!

I'm somewhat new to Access (see other post)and I'm having some trouble
designing a report.  The page looks perfect in print preview.  All
headers, data, and footers display properly.  The problem is that every
other page is blank.  Page one looks good and is noted as "Page 1".

I have a report Client in this report I have a sub report Items where Client
and Items are linked bu Client ID
How can I do the following:
When I open the report I have the Items displayed in this way:

Dear All, I have a document that contains of more than 100 pages and needs to
be printed out every week with an info on the backside of each sheet. Is
there any way to print two-sided report pages?
Thanks in advance.

I have a subform that is dividing two different fields and creating a
percentage.  The value in my subform appears as 9.05%.  This field fomat
value is set to Percent.  The field name is [Perc of Maturation].
I transfer this field to the main form by creating a text box.  The ...

Really new at this cannot figure out how to count
specific records in a record set.  if I have 100 records
in a report I can use the count(*) to count the 100
records but if I have a field that i want to count the

I would like to have the the report name with the date it was run. I know
that when you export the report it will have the name that is listed in the
properties/Format/Caption for that report. So if it is the daily report the
name of the doc will be daily report. I would like to ...

i have bitmap as report picture property. (i need this rather than an image
control cos the picture is mostly transparent and i need the report text to
print over the picture).
i want this to be shown or not shown according to value of text field on

How can I count the number of unique groups in a report (rather than the
number of records within each group)?  Thank you.

I'm designing an order entry db for my small business. My client requires an
daily order file to be sent to them in excel, but limits each order to a
maximum of 6 products. I can get the report to export - no problem. But they
want one record for each order indicating (up to) 6 ...

Basically, I'm trying to get a report with a subreport to print all records
with the same system (TypeOfSystem) to print on the same page according to
the week and service I have selected.  I access the report from a form which
applies a query as the source.  The query shows all ...