I have an access report the currently is based on one parameter query.
[sReportDate].  This report ran fine only prompting once for the parameter
when run, and not asking again when printing.
I have added a chart subreport that is based on a different query but uses

I have set up a query Between[Enter Start Date]and [Enter End Date]. This
works fine in query. I have a sub report that calculates totals this works of
the original query
When I go to report  and enter in the dates..I have to keep repeating the

My "Sorting and Grouping" in my report looks like this:
   Field/Expression      Sort Order
   sID                   Ascending
((= Project Name          Ascending

A google search indicates there is a long-standing bug with Page Setup label
margins reverting to strange numbers, but I have not found a post with a
solution.  Any pointers will be be greatly appreciated.
Best,

I am trying to force a new page programmatically on a group footer that I
created.  The field expression is "=1", and property name is AssignmentGroup.
This is not working.
   Reports![rptResume].Section(AssignmentGroup).ForceNewPage = 1

I have custom half-sheet labels for our calibration system.
The sheets have one label across and 9 labels down
I have a label template setup that prints sheets of labels from access - no
problem.

When I place the subject phrase in a text box in most reports it works fine.  
However, it does not work in a particular report.  I have tried it in page
and report footers.  I have entered it manually and with the expression that
comes with Access.  I have copied text boxes that ...

I am setting up a report.  In this report, I have a field that is populated
from a query with the average seconds that a person is on a phone call.  I'm
trying to get the numbers to calculate to the HH:MM:SS format.

I have a report that is based on a crosstab query. This is a cash projection
report that calculates upcoming cash outlays by week. That is how much we owe
next week (week 1) and how much we owe in 2 weeks (week 2) and so on through
Week 9+.  My problem is that I don't always have ...

I have a control on a report, what I'd like to do is display the text "PAL"
if the content/value of the text/control is equal to -1, if the control's
value is 0, then, show "SFSV"
Is this possible? If it is how does one get it done?

I have a report that has a group that I created to display a footer (=1).  In
that footer I have labels that act as column headings.  Directly under the
labels is a sub-report that prints the rows of data.  The data may span
across several pages, but I only want the labels to ...

Usually when I want to use a calculated field in the detail section of a
report, I create that field in the underlying query, and then bind that field
to a text box control.  I am now attempting a more complex calculated field
(string type) that looks at 14 other fields in the ...

I have a report shows RESERVE HOURS. I would like to
change it to RESERVE DAYS.
EX: SESERVE HOURS
      48      

i want to create report with drill down facuilty in MS Access Report
Means
When I Click on One field in Preview Mode then another report show it
declared report like in Active Report Tool for VB but i want this facuilty in

I want production to enter into a form the product code, manufactured date,
lot#, received date - where the lot# and received date together make the
record unique.  I created a label report based on this form but want them to
be able to print out the labels only for the newest ...